Show all data when no parameter values are entered

  • Thread starter Thread starter C. Sharp
  • Start date Start date
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?
 
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)
 
Back
Top