How to check for completed records?

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

Guest

After entering data, there should be 3 records for each [member] in the
query. How do I collect the list of [members] that do not have 3 records?
 
Something like

Select MemberName, Count(*) from MyTableOrQuery Group by MemberName where
Count(*) < 3

However it gets more complex as if a member has no entries, their name will
not be shown.

As Duane says, can you post how far you have got and perhaps details of the
Members Table and the query?
 
Thanks, that did it

JohnFol said:
Something like

Select MemberName, Count(*) from MyTableOrQuery Group by MemberName where
Count(*) < 3

However it gets more complex as if a member has no entries, their name will
not be shown.

As Duane says, can you post how far you have got and perhaps details of the
Members Table and the query?

chetNeedsSomeHelp said:
After entering data, there should be 3 records for each [member] in the
query. How do I collect the list of [members] that do not have 3 records?
Click to expand...
Click to expand...
 
Back
Top