Start and End Dates on Report Header

F

Frank

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

Rick Brandt

Frank said:
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.
Click to expand...

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]
 
F

Frank

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


Rick Brandt said:
Frank said:
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.
Click to expand...

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]
Click to expand...
 
F

fredg

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.
Click to expand...

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'
 
Top