All Dates within a specified date range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to have all dates returned from a query with start and end
parameters..
For example if the range is from 01/01/2005 to 01/15/2005 I need the report
to include those dates regardless if they are in the table queried or not.

Suggestions would be greatly appreciated
 
I need to be able to have all dates returned from a query with start and end
parameters..
For example if the range is from 01/01/2005 to 01/15/2005 I need the report
to include those dates regardless if they are in the table queried or not.

Suggestions would be greatly appreciated
Click to expand...

If you just want a control on the report header to indicate the range
entered, set an unbound control's Control Source to:

= "For Sales between " & [Start Date] & " and " & [End Date]

where the bracketed [Start Date] and [End Date] are the exact text of
the bracketed query parameter prompt.
 
I am sort of having the same problem.
First I have a field called Date Shipped. I have a query that prompts the
user to input the date range to pull in all the records. So under the Date
Shipped field in the query I have Between [Enter date] and [Enter date].
The date range for Date Shipped will vary time to time. The prompt works
fine and pulls in the correct data.

However, on the report I want the header to show what date range they
entered at the prompt. I have entered ="Shipped Between " & [Date Shipped] &
" And " & [Date Shipped] but I am not getting the results I want.

I entered 1/1/05 to 6/30/05 on the prompt but the header shows Shipped
Between 2/22/05 and 2/22/05 which happens to be the date of the first record
that is pulling in. I want the header to read Shipped Between 1/1/05 and
6/30/05.

Thanks in advance for all your help!

fredg said:
I need to be able to have all dates returned from a query with start and end
parameters..
For example if the range is from 01/01/2005 to 01/15/2005 I need the report
to include those dates regardless if they are in the table queried or not.

Suggestions would be greatly appreciated
Click to expand...

If you just want a control on the report header to indicate the range
entered, set an unbound control's Control Source to:

= "For Sales between " & [Start Date] & " and " & [End Date]

where the bracketed [Start Date] and [End Date] are the exact text of
the bracketed query parameter prompt.
Click to expand...
 
_ said:
I am sort of having the same problem.
First I have a field called Date Shipped. I have a query that
prompts the user to input the date range to pull in all the records.
So under the Date Shipped field in the query I have Between [Enter
date] and [Enter date].
The date range for Date Shipped will vary time to time. The prompt
works fine and pulls in the correct data.
Click to expand...

First off if your two parameter markers have the exact same text in them
Access will only prompt you once and apply the same value to both parameters
so I don't think your parameter markers are exactly what you posted here.
For this discussion I'll assume they are [Enter Start Date] and [Enter End
Date]

Second, in your report you need to use the same text as in your parameter
markers if you want to see what was entered by the user.

="Shipped Between " & [Enter Start Date] & " And " & [Enter End Date]
 
Thanks that worked. That makes a lot of sense now!

Rick Brandt said:
_ said:
I am sort of having the same problem.
First I have a field called Date Shipped. I have a query that
prompts the user to input the date range to pull in all the records.
So under the Date Shipped field in the query I have Between [Enter
date] and [Enter date].
The date range for Date Shipped will vary time to time. The prompt
works fine and pulls in the correct data.
Click to expand...

First off if your two parameter markers have the exact same text in them
Access will only prompt you once and apply the same value to both parameters
so I don't think your parameter markers are exactly what you posted here.
For this discussion I'll assume they are [Enter Start Date] and [Enter End
Date]

Second, in your report you need to use the same text as in your parameter
markers if you want to see what was entered by the user.

="Shipped Between " & [Enter Start Date] & " And " & [Enter End Date]
Click to expand...
 
Hi,

I think I have a similar problem in my report. My control source for my text is below:
="Date Range " & [Forms]![Report Date Range]![Beginning Order Date] & " And " & [Forms]![Report Date Range]![Ending Order Date]

I got the result of #Name?

MY report has a query source of a crosstab query which has another source where the actual paramaters are. I don't know if this has any effects. My parameter markers are [Forms]![Report Date Range]![Beginning Order Date] and [Forms]![Report Date Range]![Ending Order Date].

Please help, I would appreciate it so much. Thanks in advance.

margrac
 
Back
Top