By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,019 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.