How do I find which forms have a particular field which is blank?
in [Queries]
|
Prev: MESSAGE BOX DISPLAYS INPUT CHARACTERS
Next: default footnotes instead of endnotes in moving from text
From: Bunximo on 31 Jan 2010 08:35 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.
From: Jerry Whittle on 31 Jan 2010 13:55
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 . -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Bunximo" wrote: > 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. |