Sort Inactive

[Guest]

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?

 

[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

 

[Dirk Goldgar]

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

Correction: if it's a date field, put

Is Null

(two words).

 

[Guest]

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,
(e-mail address removed)

ps: thanks to Rick and Dirk for their thoughtfullness!