Creating query to print specific records

[halt4814]

I have a form containing thousands of records. Is there a way to create a query that will only display the records that contain data in a specific field. For example, some records have data in this one particular field. Other records do not. I want to make a query that prints the records that do contain data in that specific field. Any help?

[Gary Frazier]

Use the Is Not Null In the query of the field you have the date and it will only pull the ones with data. Is Null will pull the ones that do not have data.

[halt4814]

Where is that option at?

[Gary Frazier]

You will need to build a query against the table where the records are stored and use the Is Not Null in the criteria of the field you want to search from. Include all fields you want to see in the result.

[Missinglinq]

1. Create a Query in Design View
2. Include the appropriate Fields
3. In the Criteria Box for the Field in question enter <>IsNull([YourFieldName])
4. Save the Query

Linq ;0)>