Access Summing

  • Thread starter Thread starter Sal
  • Start date Start date
S

Sal

Hello me again
I am still not sure how I get the following (despite
already having been answered).
I need to run a query that produces the total sales for a
given month.
I have used the query between and arrived at the correct
month, but how do I get a total for that month.
I have entered =sum(XXXXXX) in the criteria section, but
no joy.
Please someone be patient and give me a step by step
guide before I write it all out on a piece of paper.
It's not good to see a grown woman cry.
Regards again
 
You need a Totals query, which begins in normal query
design mode. Drag the field you'd like to total, and the
field or combination of fields on which you'd like to
perform the total. Switch to Totals mode (View, Totals),
then change the default "Group By" in the Totals row
to "Sum" for the field you'd like total. This query will
produce a total for each unique combination of the field's
designated "Group By".

For example, if you'd like a total sales of each product
sold in each regional manager's territory, you'd Group By
Product and Regional Manager and sum the sales. If you
need only a single total for each product, group by only
the Product field.

If this doesn't answer your ?, please post your table's
structure, and identify what you want to sum.

HTH
Kevin Sprinkel
 
You are a gem. I will try this and hoefully it will work -
thank you so much.
I could be back in touch though!!!
Kind regards.
Sal
 
Back
Top