Date Range Form/Query (1 Viewer)

SpiritedAway

Registered User.
Local time
Today, 15:12
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
 

SpiritedAway

Registered User.
Local time
Today, 15:12
Joined
Sep 17, 2009
Messages
97
Ah! the OR criteria that would work:

between Forms![ReportForm]![BeginOrderDate] and Forms![ReportForm]![EndOrderDate] Or
between Forms![ReportForm]![InterimOrderDate] and Forms![ReportForm]![PostOrderDate]

To return records for both sets of dates.
 

Users who are viewing this thread

Top Bottom