Create Parameter Defined Query with Default Parameter "All"

[jmitchelldueck]

Hi,



I want to create a query that uses a name as the parameter for the records it retrieves. However, I also want to have a query to retrieve the exact same records, without giving a parameter. Is it possible to create this in one query or do I have to make two distinct ones?

Thanks.

[June7]

I NEVER use dynamic parameterized queries.

Review:

http://datapigtechnologies.com/flash...tomfilter.html

http://www.allenbrowne.com/ser-62.html