Showing Date Filter On Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jackie - 30 Sep 2003 16:39 GMT

I date filter a report but it doesn't show this date range
on the report itself.. can anyone help on how I can do
this??

Thanks

Reply to this Message

Fredg - 30 Sep 2003 17:31 GMT

If the query criteria is written as:
Between [Enter Start Date] And [Enter End Date]
then add an unbound control to the report header.
Set it's control source to something like:
= "For Sales between " & [Enter Start Date] & " And " & [Enter End Date]
The text within the brackets must be identical to the bracketed text in the
query.

If the parameters are add via a form, then
= "For Sales between " & Forms!FormName!StartControl & " And " &
forms!FormName!EndControl
The form must be open when the report is run.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

> I date filter a report but it doesn't show this date range
> on the report itself.. can anyone help on how I can do
> this??
>
> Thanks

Reply to this Message

JACKIE - 30 Sep 2003 21:17 GMT

Fred.. I have a form pop up when I click on the report so
that I may filter out date, suppler, ect. This is the
code that I have for the date filter...

Private Sub Date_Filter_Click()
DoCmd.OpenReport "rptINVENTORY",
acViewPreview, , "[Rec'dDate] Between #" &
Me.BeginningDate & "# And #" & Me.EndingDate & "#"
End Sub

So according to your information, I need to add to this to
the code: Forms!Formname!startcontrol

After I put this in .. The date should show up on report?

Thanks Again

>-----Original Message-----
>If the query criteria is written as:
[quoted text clipped - 23 lines]
>
>.

Reply to this Message

Fredg - 01 Oct 2003 00:08 GMT

Jackie,
After you change my generic
Forms!Formname!startcontrol
to
forms!NameOfYourForm!BeginningDate
and then also use
forms!NameOfYourForm!EndingDate

it should display those dates in the report.
Don't forget to place the actual name of your form where I have
NameOfYourForm.

= "For Sales between " & forms!NameOfYourForm!BeginningDate & " and " &
forms!NameOfYourForm!EndingDate

The form must be open when you run the report.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

> Fred.. I have a form pop up when I click on the report so
> that I may filter out date, suppler, ect. This is the
[quoted text clipped - 44 lines]
> >
> >.

Reply to this Message