How do I find which forms have a particular field which is blank?

  • Thread starter Thread starter Bunximo
  • Start date Start date
B

Bunximo

I have created a database using Access 2007 but it really confuses me. I used
to have Access 2000 and it was really easy to create a query which found all
the forms which had the "Date Completed" field blank, so i could find which
records were still ongoing. It even made a little list for me in a seperate
sheet. I have no idea how to do this in Access 2007 and the help forums don't
make much sense to me. Can anyone
help?

many thanks,

Bunximo.
 
Open up the database. Go to the Create tab. Next go to Other box. Select
Query Design.

Pick out the table that has the records. Bring down the fields just like in
Access 2000. In the criteria for the Date Completed field, put the word Null .
 
Back
Top