Good afternoon, I have inherited a query that prompts for start and end period dates. Now, right or wrong, I would normally just hard-code these in a query (because when I'm learning about what a query does and how it works, I'll be swapping between Design and Output modes) but in this case there are 4 lines of "or" criteria. Is it possible to have just one place where I can hard-code the required dates and then reference this within those criteria lines? It drives me nuts having to enter these dates each time when I'm figuring out the query.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.