Referencing Dates in Reports

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

Guest

Quick question on placing a TextBox with the following control source being
="Report Period From" & " " & [Enter Start Date] & " " & "Through" & " " &
[Enter End Date]
This is really good for indicating the Report Period within the Report
Header section which is what I need to do but, I am having trouble because I
have a Dialog Box that returns the values select by "GroupName" selected and
Start Date and End Date. My dialog box works fine, but it prompts me for the
Start date and End date again before opening the report.... I really do want
the reporting period within my report header so any suggestions....

Thanks
 
Hi,
you can pull the parameters without asking for them again.
Check this:
http://www.databasedev.co.uk/printing_parameters.html
BUT...normally it is advised to create a custom form with two textbox
controls on it. Then reference these in the criteria instead. This way you
are much more flexabile and can include the values entered anywhere in the
report.
HTH
Good luck
 
I am pulling the dates from the Dialog box ("it is advised to create a custom
form with two textbox
controls on it. Then reference these in the criteria instead". ) that is pulling the data from the qry. I downloaded instructions you pointed me to and this is not working. Any other suggesstions.
Click to expand...

Thanks

freakazeud said:
Hi,
you can pull the parameters without asking for them again.
Check this:
http://www.databasedev.co.uk/printing_parameters.html
BUT...normally it is advised to create a custom form with two textbox
controls on it. Then reference these in the criteria instead. This way you
are much more flexabile and can include the values entered anywhere in the
report.
HTH
Good luck
--
Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps - :)


Melissa said:
Quick question on placing a TextBox with the following control source being
="Report Period From" & " " & [Enter Start Date] & " " & "Through" & " " &
[Enter End Date]
This is really good for indicating the Report Period within the Report
Header section which is what I need to do but, I am having trouble because I
have a Dialog Box that returns the values select by "GroupName" selected and
Start Date and End Date. My dialog box works fine, but it prompts me for the
Start date and End date again before opening the report.... I really do want
the reporting period within my report header so any suggestions....

Thanks
Click to expand...
Click to expand...
 
Hi,
try the form method! Create a form with two controls on it. Now reference
these instead in the criteria:

BETWEEN [Forms]![YourForm]![StartDateControl] AND
[Forms]![YourForm]![EndDateControl]

Now on the report you can reference them in the same manner. This way you
have much more control. The other method should have worked as well though!
HTH
Good luck

--
Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
http://www.oli-s.de


Melissa said:
I am pulling the dates from the Dialog box ("it is advised to create a custom
form with two textbox
controls on it. Then reference these in the criteria instead". ) that is pulling the data from the qry. I downloaded instructions you pointed me to and this is not working. Any other suggesstions.
Click to expand...

Thanks

freakazeud said:
Hi,
you can pull the parameters without asking for them again.
Check this:
http://www.databasedev.co.uk/printing_parameters.html
BUT...normally it is advised to create a custom form with two textbox
controls on it. Then reference these in the criteria instead. This way you
are much more flexabile and can include the values entered anywhere in the
report.
HTH
Good luck
--
Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps - :)


Melissa said:
Quick question on placing a TextBox with the following control source being
="Report Period From" & " " & [Enter Start Date] & " " & "Through" & " " &
[Enter End Date]
This is really good for indicating the Report Period within the Report
Header section which is what I need to do but, I am having trouble because I
have a Dialog Box that returns the values select by "GroupName" selected and
Start Date and End Date. My dialog box works fine, but it prompts me for the
Start date and End date again before opening the report.... I really do want
the reporting period within my report header so any suggestions....

Thanks
Click to expand...
Click to expand...
Click to expand...
 
I do have a form with controls on it, that is what was messing me up. But,
good news, I did a text box with the following expression:

=Forms!SupervisorRptDialog![Start Date] & " " & "Through" & " " &
Forms!SupervisorRptDialog![End Date]

and it worked.. Thanks for the help and the reference to that web site. Lots
of good info on that one.




freakazeud said:
Hi,
try the form method! Create a form with two controls on it. Now reference
these instead in the criteria:

BETWEEN [Forms]![YourForm]![StartDateControl] AND
[Forms]![YourForm]![EndDateControl]

Now on the report you can reference them in the same manner. This way you
have much more control. The other method should have worked as well though!
HTH
Good luck

--
Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
http://www.oli-s.de


Melissa said:
I am pulling the dates from the Dialog box ("it is advised to create a custom
form with two textbox
controls on it. Then reference these in the criteria instead". ) that is pulling the data from the qry. I downloaded instructions you pointed me to and this is not working. Any other suggesstions.
Click to expand...

Thanks

freakazeud said:
Hi,
you can pull the parameters without asking for them again.
Check this:
http://www.databasedev.co.uk/printing_parameters.html
BUT...normally it is advised to create a custom form with two textbox
controls on it. Then reference these in the criteria instead. This way you
are much more flexabile and can include the values entered anywhere in the
report.
HTH
Good luck
--
Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps - :)


:

Quick question on placing a TextBox with the following control source being
="Report Period From" & " " & [Enter Start Date] & " " & "Through" & " " &
[Enter End Date]
This is really good for indicating the Report Period within the Report
Header section which is what I need to do but, I am having trouble because I
have a Dialog Box that returns the values select by "GroupName" selected and
Start Date and End Date. My dialog box works fine, but it prompts me for the
Start date and End date again before opening the report.... I really do want
the reporting period within my report header so any suggestions....

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