SpiritedAway
Registered User.
- Local time
- Yesterday, 20:38
- Joined
- Sep 17, 2009
- Messages
- 97
I have a form [ReportForm] with two unbound text boxes to select a date range.
[BeginOrderDate] & [EndOrderDate]
These two boxes look up a query with the following expression:
between Forms![ReportForm]![BeginOrderDate] and Forms![ReportForm]![EndOrderDate]
However in my query I have several other columns with dates [InterimOrderDate] & [PostOrderDate].
Can anyone advise how to modify the expression above to look up these dates as well so that when typing in a date range in the form the query will return records where the date range filters records for [BeginOrderDate], [EndOrderDate], [InterimOrderDate] & [PostOrderDate].
i'm using Access 2007
[BeginOrderDate] & [EndOrderDate]
These two boxes look up a query with the following expression:
between Forms![ReportForm]![BeginOrderDate] and Forms![ReportForm]![EndOrderDate]
However in my query I have several other columns with dates [InterimOrderDate] & [PostOrderDate].
Can anyone advise how to modify the expression above to look up these dates as well so that when typing in a date range in the form the query will return records where the date range filters records for [BeginOrderDate], [EndOrderDate], [InterimOrderDate] & [PostOrderDate].
i'm using Access 2007