Sum function in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know there is most likely a simple solution but i am just learning the
ropes with access and the whole VBA experience. I have a simple table with
Item and purchase number and purchase amount. then i set up a query recalling
all three to put into a report. I wanted to sum the total purchases in my
query also. I can set it up to where it just has the sum or just has the
other 3 inputs but i can't seem to combine them.
 
Not in one query but in two. In query design view add the summing query and
pull the total field down to the FIELD row of the grid.

You should put the sum in the report.
 
If you are using Access for the report, then do the sum in the report.

Add a group level (In the report) and in the group footer you can put a control
with a source of =Sum([Purchase Amount]). You can sum also at the Report level
in the REPORT footer (not the Page footer).
 
Back
Top