Same Date Range Parameter for 2 fields
Posted on 2006-10-25
I have a "Between" date range parameter for a query field named "Date of Service". How can I utilize these same dates as criteria for another field in the same query, without having the user prompted again for the 2 dates?
e.g., I want the records selected for the second field to be based on the same date range parameter as specified for the first, automatically.
I am working in the Select Query design view (I can do OK writing expressions, but not very comfortable writing SQL statements)