Excluding records

[qwe1204]

I have a table in an access db which holds information about bank account numbers. An account can appear in the table more than once with a different status code. I need to see if an account has all the possible status codes and exclude them from the recordset if they have.

The records appear in a format similar to the following...

Account no. Status
12345678 9
12345678 38
12345678 49
12345678 52
87654321 9
87654321 49 etc...

 

[Frink]

Hallo,

If you make a primary key (or other index) containing just the Account Number and Status fields. This will stop an account having the same status twice. Then you can just count the number of entries for each account number (use group by account number in a query). If this is the number of status values then they are all 'used up' and that account number can be omitted.

- Frink