Report Date

  • Thread starter Thread starter Roger
  • Start date Start date
R

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
 
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.
 
-----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.
Click to expand...
Click to expand...
Thanks I found what I did wrong, it works
Thanks Very Much
 
Back
Top