By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,704 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Filtering Dilema!

P: n/a
aww
Hi all,

I'm having a hard time finding a creative way to mark a block of records
based on a single condition within the recordset:

Record | Client | Date | Attendance |
======================================|
1 | A.B. | 2/1/04 | Yes |
------------------------------------- |
2 | A.B. | 2/2/04 | Yes |
------------------------------------- |
3 | A.B. | 2/3/04 | No |
------------------------------------- |
4 | A.B. | 2/4/04 | No |
------------------------------------- |
5 | A.B. | 2/5/04 | No |
-------------------------------------

I would like to create a query that, based on "Attendance = No", will NOT
show ANY of the client's 5 records; Basicaly, omit the entire client if he
has one or more "No" conditions in the field.

Any ideas will be greatly appreciated!

aww.

Access 97
--
Many Thanks!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
qryFirst: SELECT DISTINCT Client FROM tbl WHERE Attendance="No"
qrySecond: a difference query between the original tbl and qryFirst.

Herbert

"aww" <aww@no_spam.com> bl
news:Cx******************@newsread2.news.pas.earth link.net g...
Hi all,

I'm having a hard time finding a creative way to mark a block of records
based on a single condition within the recordset:

Record | Client | Date | Attendance |
======================================|
1 | A.B. | 2/1/04 | Yes |
------------------------------------- |
2 | A.B. | 2/2/04 | Yes |
------------------------------------- |
3 | A.B. | 2/3/04 | No |
------------------------------------- |
4 | A.B. | 2/4/04 | No |
------------------------------------- |
5 | A.B. | 2/5/04 | No |
-------------------------------------

I would like to create a query that, based on "Attendance = No", will NOT
show ANY of the client's 5 records; Basicaly, omit the entire client if he
has one or more "No" conditions in the field.

Any ideas will be greatly appreciated!

aww.

Access 97
--
Many Thanks!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.