Referencing Dates in Reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Melissa - 05 Jan 2006 20:58 GMT

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

Reply to this Message

freakazeud - 05 Jan 2006 22:27 GMT

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

Signature

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" & " " &
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

Melissa - 06 Jan 2006 15:03 GMT

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.

Thanks

> Hi,
> you can pull the parameters without asking for them again.
[quoted text clipped - 18 lines]
> >
> > Thanks

Reply to this Message

freakazeud - 06 Jan 2006 15:10 GMT

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

Signature

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

> I am pulling the dates from the Dialog box ("it is advised to create a custom
> form with two textbox
[quoted text clipped - 24 lines]
> > >
> > > Thanks

Reply to this Message

Melissa - 06 Jan 2006 15:46 GMT

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.

> Hi,
> try the form method! Create a form with two controls on it. Now reference
[quoted text clipped - 36 lines]
> > > >
> > > > Thanks

Reply to this Message