Use criteria or return all records

[Cosmos75]

I have this for a query.

SELECT [Field1], [Field2]
FROM [Table1]
WHERE [Field1]=NZ([SearchThis],[Field1]);

I want to return all records if [SearchThis] is not entered. If [SearchThis] is entered, then use [SearchThis] as criteria.

It returns all records where [Field1] <> Null but I also want to return records that are Null (i.e. return all records).

 

[Mile-O]

In the criteria of the query design put:

[Forms]![MyForm]![MyControl] OR [Forms]![MyForm]![MyControl] Is Null

Once saved and reopened in design view the query will have fixed the correct structure for you.

 

[Cosmos75]

Thanks, Mile-O-Phile!