Hello. I am trying to insert a text box at the bottom of a sales report that calculates the total of one of the columns (in this case, net sales).
I can get a running sum, for this, but not just one final total. Is there a way in the report to get the result? Or, should I approach this from the query? But if I do it this way, I can't see how I can avoid having the total attached to each record (and then in the report). If I create a separate query getting this amount, and try to add it into my report,I get a conflict stating something like "your choosing two different querys from the same table, try using one or the other".
Any idea what to do?
I can get a running sum, for this, but not just one final total. Is there a way in the report to get the result? Or, should I approach this from the query? But if I do it this way, I can't see how I can avoid having the total attached to each record (and then in the report). If I create a separate query getting this amount, and try to add it into my report,I get a conflict stating something like "your choosing two different querys from the same table, try using one or the other".
Any idea what to do?