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

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.
 
J

Jerry Whittle

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 .
 

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

Top