Hello, I have multiple products, in a query I want to condense to

[Guest]

Hello,
I have multiple Regions that contain Districts with sales dollars in both.
In a query I would like to sumarize to one line for each region and district
for sales dollars . Also can you explain how "where"(aggregate function) is
used in totals.

Thanks

 

[John W. Vinson]

Hello,
I have multiple Regions that contain Districts with sales dollars in both.
In a query I would like to sumarize to one line for each region and district
for sales dollars .

Group By the region and district, and Sum the sales. I'm not sure that's what
you want, but that's what you asked...

Also can you explain how "where"(aggregate function) is
used in totals.

WHERE is used for fields that you want to use as search criteria to filter
which records are included in the calculations. For instance you could use
SaleDate as a field in the totals query; use WHERE on the totals line for that
field; and put

BETWEEN [Enter start date:] AND [Enter end date:]

as criteria to get totals for a particular time range.

John W. Vinson [MVP]

 

[Marshall Barton]

I have multiple Regions that contain Districts with sales dollars in both.
In a query I would like to sumarize to one line for each region and district
for sales dollars . Also can you explain how "where"(aggregate function) is
used in totals.

Use a Totals query that groups on the Region and District
fields and Sum for the sales field. Don't use any any other
fields with Show checked.

The Where option in the Totals row tells the query designer
to use the field in the WHERE clause but not in the SELECT
clause.

If you need further help with this, please post a Copy/Paste
of your query's SQL view.