Count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to count records. I think I need to add a number count..

The first variable of the record is an assigned number (entry number).
Only 5 records should have been entered per entry number.

I can do a Query with Group by, which will at least put them all together
for each entry number, but how can I add the statement "IF there are more
than 5"
I don't want to look at the data for a number 5, I want to count the number
of entry numbers with more than 5 entries..

Thanks
 
I'm trying to count records. I think I need to add a number count..

The first variable of the record is an assigned number (entry number).
Only 5 records should have been entered per entry number.

I can do a Query with Group by, which will at least put them all together
for each entry number, but how can I add the statement "IF there are more
than 5"
I don't want to look at the data for a number 5, I want to count the number
of entry numbers with more than 5 entries..

Thanks
Click to expand...

Create a Totals query with the Group By as you have done; select any
field from the table (it can be the Entry Number if you wish) in a
second column. Put Count on the Totals line under this field, and
5
Click to expand...

on the criteria line under this Count.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Yup, that worked.
Thanks

John Vinson said:
Create a Totals query with the Group By as you have done; select any
field from the table (it can be the Entry Number if you wish) in a
second column. Put Count on the Totals line under this field, and


on the criteria line under this Count.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
Back
Top