All or selected Query

[Valerie Wong]

I have a query to run summary of projects. The criteria of the query would be
the project name. However in some cases, instead of showing just one of the
projects I would like the query to show all projects. How could I do this?

Many thanks for any help!

 

[Ken Snell MVP]

Assuming you use a parameter for the project name:

SELECT *
FROM TableName
WHERE ProjectNameField =
[Enter project name:] OR
Len([Enter project name:] & "") = 0;