Reference the Date in report footer.

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

Re: Reference the Date in report footer.

Much neater to open a date input form on the OnOpen Event of the report. The
date input form can usefully have a few buttons on it like Now (EndDate),
begining of the year (StartDate) etc as well as a StartDate and EndDate that
optionally can be filled in. Then the report header /footer can load the
information from the form. The other advantage is that you can check whether
sensible dates have been entered and that the format is correct with '#'
marks etc

Phil

"Fred's" wrote in message
news:faff7aa3-8376-4726-aeee-1e391bc1f7fe@e23g2000prf.google groups.com...
> 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

Re: Reference the Date in report footer.

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

Re: Reference the Date in report footer.

On Jan 15, 5:10=A0pm, fredg wrote:
> 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 =A0Start 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:
> =3D"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.

Re: Reference the Date in report footer.

Fred's wrote:
> On Jan 15, 5:10 pm, fredg wrote:
>> 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.

Re: Reference the Date in report footer.

donald wrote:
> Fred's wrote:
>> On Jan 15, 5:10 pm, fredg wrote:
>>> 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.