Show all data when no parameter values are entered

C

C. Sharp

Is there a way to enter a Parameter entry in a query that if you enter NO
data it will show ALL data. For example, [Enter project code] is left blank
and it will show all projects currently listed in the db?
 
B

Bob Barrows [MVP]

C. Sharp said:
Is there a way to enter a Parameter entry in a query that if you
enter NO data it will show ALL data. For example, [Enter project
code] is left blank and it will show all projects currently listed in
the db?
Click to expand...
WHERE ([Project Code] = [Enter project code] OR [Enter project code] Is
Null)
 
Top