summary query

[Meejung]

I have a tracking database I am trying to create a summary report for. The
database tracks the different reasons for calls. How do I create a query
which will give me a numerical total for the different categories? Thanks
for any help you can provide.

 

[scubadiver]

Assuming that database is properly normalised just create a totals query

select category, count(category)
from table
group by category

 

[Jeff Boyce]

As [scubadiver] points out, we can only assume what data structure you have.

If you want specific suggestions on "how to", please provide specific
information about your data -- it all starts with the data!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Meejung]

Since this last post I have managed to create the query which gives me the
totals for each of the categories in the tables such as customer call, item
number, miscellaneous, etc. The problem is I can't limit the call counts to
just last month. It is pulling all of the data from the time the database
was created. When I go in and add a column and under total I choose where
and add the following under criteria:

=DateSerial(Year(Date()),Month(Date())-1,1) And <DateSerial(Year(Date()),Month(Date()),1)

it doesn't give me any data. This expression worked when I used it in
another query to limit the data returned. What am I doing wrong?

Thanks

 

[scubadiver]

I didn't think Excel functions could work in Access ????

Are your dates in text format or in 'date/time' format?

 

[Douglas J. Steele]

What "Excel functions" are you talking about?

=DateSerial(Year(Date()),Month(Date())-1,1) And
<DateSerial(Year(Date()),Month(Date()),1)

doesn't use anything that's not available through VBA in Access.