Start and End Dates on Report Header

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank - 19 Jul 2005 14:55 GMT

I have a report built on a query which is built on a table

In the query, I have a field called [Date]. In the criteria section, I have
a Between [Enter Start Date] And [ Enter End Date] expression so that users
can limit the data to a data range.

What I want to do is place two text boxes in the header of the Report that
will reflect the Start and End Dates the users enter.

What is the best way to do this?

Any assistance is greatly appreciated.

Reply to this Message

Rick Brandt - 19 Jul 2005 14:59 GMT

> I have a report built on a query which is built on a table
>
[quoted text clipped - 8 lines]
>
> Any assistance is greatly appreciated.

If you use those EXACT same expressions in a TextBox ControlSource on the
report they will be displayed.

EXAMPLE:

="For Records Dated Between " & [Enter Start Date] & " and " & [Enter End
Date]

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Frank - 19 Jul 2005 15:59 GMT

Thanks Rick for most helpful comments. Tried and all worked great.

>> I have a report built on a query which is built on a table
>>
[quoted text clipped - 16 lines]
> ="For Records Dated Between " & [Enter Start Date] & " and " & [Enter End
> Date]

Reply to this Message

fredg - 19 Jul 2005 17:25 GMT

> I have a report built on a query which is built on a table
>
[quoted text clipped - 8 lines]
>
> Any assistance is greatly appreciated.

Rick Brandt gave you your answer.

Additionally...
Date is a reserved Access/VBA/Jet word and should not be used as a
field name.
See the Microsoft KnowledgeBase article for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message