parameter query

[IanT]

Is it possible that when you run a parameter query, that if no info is inputted, the query will show all details!

 

[RV]

Yes, it's possible.

WHERE Table.Field=[your parameter]
OR [your parameter] is null;