Trying to have sums and individual records on the same page (picture included)

[BenW]

well i tried asking for help on this earlier, but i wasn't able to find any help so here is my problem.



the sales - net = profit is fine but what i want to do is have a totals at the very bottem. everytime i try to do this, i can only get the totals to show and each individual record dissapears, or nothing shows at all. i've tried using a report but i can't seem to pull it off either. if anyone knows what i'm talking about and knows what i have to do then please help me

 

[KenHigg]

You screen shot is too small to read...

 

[pbaldy]

Most of us never display a query directly to the user, so the totals would be done in the form or report. Doing it in a query can be accomplished with a UNION query, where the first component is your existing query, and the second is a query that sums the amounts.

 

[BenW]

well i tried playing around with a report but i couldn't figure out a way to combine the 2 queries so i decided i'd try using queries instead. i already have both queries, one with each seperate record and the other with the total sum but i don't know how to unite them together.