Select specific records in query (1 Viewer)

rhomer

Registered User.
Local time
Today, 06:43
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:

pcs

Registered User.
Local time
Today, 00:43
Joined
May 19, 2001
Messages
398
try:

Is Not Null

for the criteria...

hth,
al
 

Users who are viewing this thread

Top Bottom