Count in query

[magmike]

I need to display the count of records there are for each unique value
in a table. In this case, it is by date - how many calls are scheduled
for each date. Each call is a record in a table. So the results of the
query would look like this:

08/17/07 - 16
08/18/07 - 13
08/20/07 - 21
08/21/07 - 03
08/23/07 - 09
09/20/07 - 03
01/05/08 - 01

I've been using a crosstab query, but I know there has to be a better
way, because I feel like I have been manipulating the purpose of the
crosstab wizard to get what I want. I want to be able to accomplish
this through design view.

Thanks in advance for your help!

[Tom van Stiphout]

On Thu, 16 Aug 2007 15:02:07 -0000, magmike <ma******@yahoo.com>
wrote:

Create a new query. Select your table. Drag the date field to the grid
twice. Hit the sum button. Change the second GroupBy to Count.

-Tom.

>I need to display the count of records there are for each unique value
in a table. In this case, it is by date - how many calls are scheduled
for each date. Each call is a record in a table. So the results of the
query would look like this:

08/17/07 - 16
08/18/07 - 13
08/20/07 - 21
08/21/07 - 03
08/23/07 - 09
09/20/07 - 03
01/05/08 - 01

I've been using a crosstab query, but I know there has to be a better
way, because I feel like I have been manipulating the purpose of the
crosstab wizard to get what I want. I want to be able to accomplish
this through design view.

Thanks in advance for your help!

[magmike]

On Aug 16, 10:20 am, Tom van Stiphout <[e-mail]:

On Thu, 16 Aug 2007 15:02:07 -0000, magmike <[e-mail]>
wrote:

Create a new query. Select your table. Drag the date field to the grid
twice. Hit the sum button. Change the second GroupBy to Count.

-Tom.

I need to display the count of records there are for each unique value
in a table. In this case, it is by date - how many calls are scheduled
for each date. Each call is a record in a table. So the results of the
query would look like this:

08/17/07 - 16
08/18/07 - 13
08/20/07 - 21
08/21/07 - 03
08/23/07 - 09
09/20/07 - 03
01/05/08 - 01

I've been using a crosstab query, but I know there has to be a better
way, because I feel like I have been manipulating the purpose of the
crosstab wizard to get what I want. I want to be able to accomplish
this through design view.

Thanks in advance for your help!- Hide quoted text -

- Show quoted text -

That's fantastic. Thanks!