Yammaski Posted November 23, 2008 Share Posted November 23, 2008 On my "order_period"-page, a query result gives the records for a choosen period on the previous page (e.g.: orders for september 2008 - see attached jpg).How can I show the total of the "OrderTotal" column ?Yam. Link to comment Share on other sites More sharing options...
amj Posted November 24, 2008 Share Posted November 24, 2008 When you display each row in the table I'd have a variable that you initiate at 0 and then add the contents of each row to it so that you have a total at the end. Link to comment Share on other sites More sharing options...
Yammaski Posted November 25, 2008 Author Share Posted November 25, 2008 I don't know really what you mean !Can you please give a bit more explanation ? Link to comment Share on other sites More sharing options...
amj Posted November 25, 2008 Share Posted November 25, 2008 Before your loop that displays the table of dataGrandTotal = 0Inside the loop that displays the dataGrandTotal = GrandTotal + OrderTotalAt the bottom you can then display GrandTotal where ever you want to do so. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.