Reference the Date in report footer.

[Fred's]

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

[Fred's]

On Jan 15, 5:10*pm, fredg <[e-mail]:

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.

[donald]

Fred's wrote:

On Jan 15, 5:10 pm, fredg <[e-mail]:

>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.

[donald]

donald wrote:

Fred's wrote:

>On Jan 15, 5:10 pm, fredg <[e-mail]:

>>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.