Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How do I
0 views
Skip to first unread message
Terry
Mar 31, 2003, 2:27:12 PM3/31/03
to
I created a query to go through a table of training
records and tell me who all has taken a certain class.
The class was class number 9035. Here there were no
problems the query searched through 10,000 records and
told me who all had taken class 9035. But I don't know
how to make it tell me who has not taken class 9035. I
have exhaused my limited ability. Can you help? Thank
you in advance for any ideas.
records and tell me who all has taken a certain class.
The class was class number 9035. Here there were no
problems the query searched through 10,000 records and
told me who all had taken class 9035. But I don't know
how to make it tell me who has not taken class 9035. I
have exhaused my limited ability. Can you help? Thank
you in advance for any ideas.
Terry
Fredg
Mar 31, 2003, 2:38:21 PM3/31/03
to
terry
If your query criteria is
= 9035 (or since = is the default, just 9035)
to find those that include 9035
then
<> 9035
will return those that did not include 9035.
If your query criteria is
= 9035 (or since = is the default, just 9035)
to find those that include 9035
then
<> 9035
will return those that did not include 9035.
--
Fred
Please reply only to this newsgroup.
I do not reply to personal e-mail.
"Terry" <tein...@walkdie.com> wrote in message
news:056301c2f7bb$87d8c2b0$2f01...@phx.gbl...
Liz McCracken
Mar 31, 2003, 2:37:41 PM3/31/03
to
In the criteria field of the Class Number enter: <>9035.
If a text field you can try NOT LIKE 9035.
Good luck!
Liz McCracken, MOS>.
>
If a text field you can try NOT LIKE 9035.
Good luck!
Liz McCracken, MOS
>
John Spencer (MVP)
Mar 31, 2003, 3:33:52 PM3/31/03
to
The easiest (and in Access, probably the fastest way) may be to use two
queries. You already have the first query built. Just use it to find unmatched
records
queries. You already have the first query built. Just use it to find unmatched
records
Something like;
QueryOne
Select EmployeeID
From TrainingAttendees
Where ClassNo = 9035
QueryTwo
SELECT TrainingAttendees.EmployeeID
FROM TrainingAttendees LEFT JOIN QueryOne
ON TrainingAttendees.EmployeeID = QueryOne.EmployeeID
WHERE QueryOne.EmployeeID Is Null
0 new messages