Prev: Query - ies - Questions
Next: How do I create a select YTD query that totals monthly summaries?
From: Meejung on 24 Jun 2008 11:08
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.
From: scubadiver on 24 Jun 2008 11:11

Assuming that database is properly normalised just create a totals query

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


"Meejung" wrote:

> 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.
From: Jeff Boyce on 24 Jun 2008 12:21
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" <Meejung(a)discussions.microsoft.com> wrote in message
news:1A6151B2-A74B-46D5-B1C7-4068186B2669(a)microsoft.com...
>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.


From: Meejung on 24 Jun 2008 14:23
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" wrote:

>
> Assuming that database is properly normalised just create a totals query
>
> select category, count(category)
> from table
> group by category
>
>
> "Meejung" wrote:
>
> > 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.
From: scubadiver on 25 Jun 2008 03:22

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

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



"Meejung" wrote:

> 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" wrote:
>
> >
> > Assuming that database is properly normalised just create a totals query
> >
> > select category, count(category)
> > from table
> > group by category
> >
> >
> > "Meejung" wrote:
> >
> > > 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.
 |  Next  |  Last
Pages: 1 2
Prev: Query - ies - Questions
Next: How do I create a select YTD query that totals monthly summaries?