Report Date

[Roger]

When a report is created which requires a start date and
a end date, from the critiria date field in a querry.
Is there a way for a report to show the start date and
end date in the header or footer?
Thanks for any help
Roger

 

[Fredg]

Roger,
Add an unbound text control to the report header.

Assuming the query criteria was
Between [Start Date] and [End Date]

Set the control's control source to something like:

="For Sales between " & [Start Date] & " and " & [End Date]

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

 

[Roger]

-----Original Message-----
Must be doing something wrong, can't get it to work, here
is what I have in the query under date in the critiria row

=[Enter Start Date(mm/dd/yy):] And <=[Enter End Date (mm/dd/yy):]
Thanks
Roger
-----Original Message-----
Roger,
Add an unbound text control to the report header.

Assuming the query criteria was
Between [Start Date] and [End Date]

Set the control's control source to something like:

="For Sales between " & [Start Date] & " and " & [End Date]

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

--
Fred

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

Thanks I found what I did wrong, it works
Thanks Very Much