A97 How do I Group by a Count?

[John]

I track daily receipts at a mailroom / loading dock (use a
barcode scanner on boxes, then import data to MS Access 97)

For statistical reporting, I have a simple report that
reads the RECEIVE table, with grouping on the DateStamp
field, and which shows the total items received by date
using a text box with =Count([DateStamp]) in a grouping
footer (I removed all of the detail information)

This works perfectly to report to the boss
Count 34 7/16/2008
Count 67 7/15/2008
Count 45 7/14/2008 - and so on

What I would like to do (for me) is have a report that
sorted by the count, so I could have
Count 67 7/15/2008
Count 45 7/14/2008
Count 34 7/16/2008

I have never before tried to group by a calculation, and
I am just not able to figure out how to make this work

I read the help and "should" be able to create a Query
that creates a summed/counted output... but I can't get
that to work either

Help!

 

[ND Pard]

Use the following query as your desired reports Record Source:

SELECT Count(RECEIVE.DateStamp), RECEIVE.DateStamp
FROM RECEIVE
GROUP BY RECEIVE.DateStamp
ORDER BY Count(RECEIVE.DateStamp) DESC;

Hope this helps.

 

[KARL DEWEY]

You have to use the Sorting and Grouping in the report as it will ignore any
sorting in the query.
In design view click on menu VIEW - Sorting and Grouping, select your count
field.

 

[John]

Thanks... works perfectly!

Use the following query as your desired reports Record Source:

SELECT Count(RECEIVE.DateStamp), RECEIVE.DateStamp
FROM RECEIVE
GROUP BY RECEIVE.DateStamp
ORDER BY Count(RECEIVE.DateStamp) DESC;

Hope this helps.

I track daily receipts at a mailroom / loading dock (use a
barcode scanner on boxes, then import data to MS Access 97)

For statistical reporting, I have a simple report that
reads the RECEIVE table, with grouping on the DateStamp
field, and which shows the total items received by date
using a text box with =Count([DateStamp]) in a grouping
footer (I removed all of the detail information)

This works perfectly to report to the boss
Count 34 7/16/2008
Count 67 7/15/2008
Count 45 7/14/2008 - and so on

What I would like to do (for me) is have a report that
sorted by the count, so I could have
Count 67 7/15/2008
Count 45 7/14/2008
Count 34 7/16/2008

I have never before tried to group by a calculation, and
I am just not able to figure out how to make this work

I read the help and "should" be able to create a Query
that creates a summed/counted output... but I can't get
that to work either

Help!