Parameter Query

[TheRealDeal]

Is it possible to pass parameter values to a query that is not bound to a form or report? For instances, say I have a query and it has [Start Date] and [End Date]; can I DoCmd.OpenQuery "qrySomething", ...([Start Date] = a starting date) and ([End Date] = a ending date).

 

[Crowley16]

yes, have a parameter query...

although if you want to automatically pass in the parameters, then you'll have to open the querydef, set the parameters, then run the query...

--------------------
Procrastinate Now!

 

[TheRealDeal]

Would you happen to have an example to get me started in the right direction?