All or selected Query

  • Thread starter Thread starter Valerie Wong
  • Start date Start date
V

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!
 
Assuming you use a parameter for the project name:

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