Filter for Access Query.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I make a query in MS Access that returns only the records in which
there is an entry in the birthdate field?

If there's no birthdate entered, I don't want to see the record in the query.
 
put


not null

in the criteria

--
Rick B



Rinkrat said:
How do I make a query in MS Access that returns only the records in which
there is an entry in the birthdate field?

If there's no birthdate entered, I don't want to see the record in the
Click to expand...
query.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2000: Data Type Mismatch in query 2
Date Field conundrum 3
Queries 2
Help - address book / DOB's, Anniversarys & Christmas list 4
Allow editing of a calculated field 4
how to avoid duplicate records 2
Criteria for only certain months of a birthdate 1
calculate age from DOB then display and manipulate those values? 2

Back
Top