Showing Date Filter On Report

  • Thread starter Thread starter Jackie
  • Start date Start date
J

Jackie

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
 
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.
 
Jackie,
This is the 3rd line of my first reply to you...
then add an unbound control to the report header.<
Click to expand...

Yes, add an unbound control to the Report Header.
Set it's control source to something like:

= " For Sales between " & Forms!frmfilterINV!BeginningDate & " And " &
Forms!frmfilterINV!EndingDate

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.


Jackie said:
Hey Fred,

Okay did whatcha said... and i printed out the report but
the date range I selected was not printed on report...

Now the filter does good, no errors after i put in what
you told me.. still filters the dates needed but no dates
printed on it?? Here is my code that you told me to do, if
you don't mind looking again:


DoCmd.OpenReport "rptINVENTORY",
acViewPreview, , "[Rec'dDate] Between #" & Forms!
frmfilterINV!BeginningDate & "# And #" & Forms!
frmfilterINV!EndingDate & "#"

Should I have to add a text box somewhere in the report
for it to be able to print the date range?

Thanks,
Jackie



-----Original Message-----

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.


JACKIE said:
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:
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


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top