Sort Inactive

K

Kelly

This has to be simple...but I must be making it more complicated. I have a
database for all our volunteers. I have an inactive colum for those who are
no longer serving, but do not want to be delete them from the data base. I
want to do a print out of only our active people. What is the query formula?
 
R

Rick B

Under the inactive field, put in criteria to exclude the inactives. If this
is a yes/no field, put...

=false

If it is a date field, put...

IsNull
 
D

Dirk Goldgar

Rick B said:
Under the inactive field, put in criteria to exclude the inactives.
If this is a yes/no field, put...

=false

If it is a date field, put...

IsNull
Click to expand...

Correction: if it's a date field, put

Is Null

(two words).
 
W

WebDude

wow.

I came to this forum looking for posts that may help me figure out the
proper syntax for ... form![datefield] = Null ... Kelly's post was the first
that came up, and not only did it answer all my questions but i was shocked -
cause im also creating a database to keep track of Volunteers! Aaaaaand i
also have the same inACTIVE column. LOL Lets swap notes :-|

cheers,
[email protected]

ps: thanks to Rick and Dirk for their thoughtfullness!
 
Top