How to check for completed records?

[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?

 

[Duane Hookom]

How far have you gotten on this? Did you try a totals/group by query?

 

[JohnFol]

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?

 

[Guest]

Thanks, that did it

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?

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?