I have a simple database i made. It has a transaction table and a line item table. On the tranaction form there is a portal to the line items. in the line items i have a number field "gallons" and a Summary filed "total of gallons" i drag on drop this outside the portal record and it shows me the total gallons in all the line items. Perfect!
now when i run a report for all transaction between a date range i get a list of all the transactions and all the line items...but my grand total is always just the last transaction total...how do i get a grand total of all found records?