Query for Report to allow choice between 2 date fields for date range

[Todd D. Levy]

Normally, I have a date field in the query that a report is based on
that requests the user to select a start date and an end date.

I now have a situation where there are 2 date fields that the user may
wish to base the report on and I want to give them a choice.

I could simply create 2 queries/reports and the user can run whichever
is required.

What I would like to do is create a single query/report that first asks
the user to select the appropriate date field, and then asks for the
start and end dates.

Is this possible?

[PC Datasheet]

You need to set up a popup form that asks for the dates and only allows one set
(Start and End Dates) to be entered. Then in your query you need to put an
expression like this in all four criteria:

Forms!NameOfPopUpForm!MyDate Or (Forms!NameOfPopUpForm!MyDate Is Null)
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Todd D. Levy" <us**************@spamex.com> wrote in message
news:MP************************@nyc.news.speakeasy .net...

Normally, I have a date field in the query that a report is based on
that requests the user to select a start date and an end date.

I now have a situation where there are 2 date fields that the user may
wish to base the report on and I want to give them a choice.

I could simply create 2 queries/reports and the user can run whichever
is required.

What I would like to do is create a single query/report that first asks
the user to select the appropriate date field, and then asks for the
start and end dates.

Is this possible?