summary query


M

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.
 
Ad

Advertisements

S

scubadiver

Assuming that database is properly normalised just create a totals query

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

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
 
M

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
 
S

scubadiver

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

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

Advertisements

D

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.
 

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

Top