summary query



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.




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!


Jeff Boyce
Microsoft Office/Access MVP


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?



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
doesn't use anything that's not available through VBA in Access.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summary query, sum by 1
Summary Query on Results of a Parameter Query 1
Summary Query - grouping by Month 1
summaries of summaries.. 1
Summary 1
system summary 1
report summary 1
Summary Table 0