Report not totalling

[Guest]

I used to be pretty good at Access but oh well,

I am trying to create a report that will total the amount of records for a
specific prompt from a query that I have.

I have one table that houses all of the data
The query is built to ask me for two things in order to pull the data.
So basically
Data 1 Data 2 Data3 Data4
Region Location Asset # Serial #
Group Group Group Count

What I am trying to get the report to do is to report based on the Region
and Location how many Serial Numbers there are.
I have tried several different things, but I am doing it wrong I am sure.

Any help is appreciated.

Thanks,

 

[Duane Hookom]

Create a totals query that groups by Region and Location while Counting
the Serial #. Use this query as the record source for your report.

If this doesn't meet your specifications, please inform us what your
specifications are.

Duane Hookom
MS Access MVP

 

[Duane Hookom]

Create a totals query that groups by Region and Location while counting the
Serial #. Use this query as the record source of your report.

If this doesn't meet your specifications, tell us what your specifications
are.