473,320 Members | 2,202 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Filtering Dilema!

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
1 1186
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> ¦b¶l¥ó
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Alex Ayzin | last post by:
Hi, I have a problem that might be easy to solve(possibly, I've just overlooked an easy solution). Here we go: I have a dataset with 2 datatables in it. Now, I need to do the following: if...
0
by: ma740988 | last post by:
Puzzled about an implementation here. In a vendor file, I'm faced: // vendors_file.h #ifdef __cplusplus typedef void (*VOIDFUNCPTR) (...); /* pfunction returning void */ #else...
3
by: Jason | last post by:
I am trying to filter records in a primary form based on records in related tables. The data in the related tables is being displayed in the primary form through subforms. To be more specific, I...
5
by: Richard | last post by:
Hi, I have a form that take some time to load due to many comboboxes and at least 8 subforms. When I filter or sort the main form I get an error message and then Access shuts down. They ask if...
10
by: milk-jam | last post by:
I'm trying to set my datagridview so that the first row will be left blank and to use it as a filtering filed for the datagridview. Until now I was using 2 datagridview the upper one with a header...
2
by: Konrad | last post by:
Hi Can you point examples in .NET of filtering (avoiding) displaying web pages with unwanted content on machine with ie? Thanks Konrad
7
by: | last post by:
Hello, Does anyone have an idea on how I can filter the data in the gridview control that was returned by an sql query? I have a gridview that works fine when I populate it with data. Now I...
2
by: JUAN ERNESTO FLORES BELTRAN | last post by:
Hi you all, I am developping a python application which connects to a database (postresql) and displays the query results on a treeview. In adittion to displaying the info i do need to implement...
3
by: Shawn Ramirez | last post by:
As with most web applications speed is a huge deal to me in my applications. My customers don't really care if my app is a true 3 tier application or not, they just want it to be faster then it was...
3
by: Harry Haller | last post by:
Hello, I want to implement a generic list which will be used to display 7 columns in a GridView. One should be able to sort, filter and page each of the 7 columns. Ideally the filter should be...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.