Select specific records in query

rhomer

Registered User.
Local time
Today, 11:51
Joined
Mar 14, 2002
Messages
18
UPDATED!: Select specific records in query

UPDATE TO MY QUESTION: In my query, I need to be able to show ONLY those records that have an entry, AT PRESENT!, in that field and no others. I have tried the "between and to" and the -1 or 0 for the criteria. These both return ALL the info that has ever been in that field. All I need is the info that is there at the moment. :confused:
 
Last edited:
try:

Is Not Null

for the criteria...

hth,
al
 

Users who are viewing this thread

Back
Top Bottom