Query for blanks

[AnnaB]

This may be an easy task for some, but I have been struggling for DAYS!
I have a very large database. In it are several tables of information. I need to create a query or report that can look at a table and give me a list showing all the records with a specific field that is blank.
Ex: Table is of Auto Parts, Fields are - Part No., Version, Plant, Description, Cust. Part No., Engineer. I need a list of all records that have nothing entered in the description field. Any advice??

 

[ivi77]

try using the "is null" option.....

 

[KeithIT]

Create a query with only that table (or linked tables if necessary). Have it show you the part name (or record number if that is easier for you to work with) and the description field only, and put the following into the criteria row of the Description field (without the quotes): "IsNull"

When you run the query it will only show you those part names (or record numbers) which have no value defined in the description field.

Alternatively, you can put "" in the criteria field to show that it has no value, however I've had some issues with this in the past (which is probably more my stupidity than anything else, but still...)

Hope that helps!