By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 2,050 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

Reference the Date in report footer.

P: n/a
Hi Folks,

I have a report which the record source is a query name: Query3 and in
my Query3 I have this parameter "between [Start Date] And [EndDate]".
Therefore, when I open my report, it will ask for a Start Date And an
EndDate.

Now I will like to have this date in the report footer of my acess
report.

Can someone tell me how can I do this?

Thanking all in advance for your help and continuous access support.
Fred's
Jan 15 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Jan 15, 5:10*pm, fredg <fgutk...@example.invalidwrote:
On Tue, 15 Jan 2008 12:59:06 -0800 (PST), Fred's wrote:
Hi Folks,
I have a report which the record source is a query name: Query3 and in
my Query3 I have this parameter "between [Start Date] And [EndDate]".
Therefore, when I open my report, it will ask for a *Start Date And an
EndDate.
Now I will like to have this date in the report footer of my acess
report.
Can someone tell me how can I do this?
Thanking all in advance for your help and continuous access support.
Fred's

Usually this is done on the report header, but you can add an unbound
text control to the report footer.

Set it's control source to:
="For sales between " & [Start Date] & " and " & [End Date]

The text within the brackets must be identical to the bracketed text
used in the query criteria.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Thank you, but this is not what I'm searching for.

This is my needs: The date that I enter the parameter need to appear
on the report footer.
Jan 16 '08 #2

P: n/a
Fred's wrote:
On Jan 15, 5:10 pm, fredg <fgutk...@example.invalidwrote:
>On Tue, 15 Jan 2008 12:59:06 -0800 (PST), Fred's wrote:
>>Hi Folks,
I have a report which the record source is a query name: Query3 and in
my Query3 I have this parameter "between [Start Date] And [EndDate]".
Therefore, when I open my report, it will ask for a Start Date And an
EndDate.
Now I will like to have this date in the report footer of my acess
report.
Can someone tell me how can I do this?
Thanking all in advance for your help and continuous access support.
Fred's
Usually this is done on the report header, but you can add an unbound
text control to the report footer.

Set it's control source to:
="For sales between " & [Start Date] & " and " & [End Date]

The text within the brackets must be identical to the bracketed text
used in the query criteria.

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

Thank you, but this is not what I'm searching for.

This is my needs: The date that I enter the parameter need to appear
on the report footer.
What you should do is create a form and add two text fields, one for the
Start Date and the other for the End Date. Let's say the form is named:
DateRange and the two text fields you create are named: StartDate and
EndDate. Then, revise your query, replacing the parameter you now have
with this: between [Forms]![DateRange]![StartDate] And
[Forms]![DateRange]![EndDate]

Now, when your query runs, the DateRange Form will open to accept the
StartDate and EndDate parameters which will be passed to StartDate and
EndDate which you can then reference in your report as
[Forms]![DateRange]![StartDate] and [Forms]![DateRange]![EndDate]. I
believe this will work.
Jan 16 '08 #3

P: n/a
donald wrote:
Fred's wrote:
>On Jan 15, 5:10 pm, fredg <fgutk...@example.invalidwrote:
>>On Tue, 15 Jan 2008 12:59:06 -0800 (PST), Fred's wrote:
Hi Folks,
I have a report which the record source is a query name: Query3 and in
my Query3 I have this parameter "between [Start Date] And [EndDate]".
Therefore, when I open my report, it will ask for a Start Date And an
EndDate.
Now I will like to have this date in the report footer of my acess
report.
Can someone tell me how can I do this?
Thanking all in advance for your help and continuous access support.
Fred's
Usually this is done on the report header, but you can add an unbound
text control to the report footer.

Set it's control source to:
="For sales between " & [Start Date] & " and " & [End Date]

The text within the brackets must be identical to the bracketed text
used in the query criteria.

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

Thank you, but this is not what I'm searching for.

This is my needs: The date that I enter the parameter need to appear
on the report footer.

What you should do is create a form and add two text fields, one for the
Start Date and the other for the End Date. Let's say the form is named:
DateRange and the two text fields you create are named: StartDate and
EndDate. Then, revise your query, replacing the parameter you now have
with this: between [Forms]![DateRange]![StartDate] And
[Forms]![DateRange]![EndDate]

Now, when your query runs, the DateRange Form will open to accept the
StartDate and EndDate parameters which will be passed to StartDate and
EndDate which you can then reference in your report as
[Forms]![DateRange]![StartDate] and [Forms]![DateRange]![EndDate]. I
believe this will work.
I should have added that you will need a button on the DateRange form
for executing the query once you have entered the dates in the two text
fields.
Jan 16 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.