Dates from query

[ladybug via AccessMonster.com]

I have a report with the control source as a query. This query consists of
one table and another query. This original query has a field called "day."
In the criteria I have Between #12/01/2007# And #12/31/2007#. I would like
in the report to have these dates captured at the top. How do I do this
since these fields are not considered apart of the control source for the
report?

 

[Allen Browne]

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

Explains 2 approaches: parameters in the query, or text boxes read from a
form.

 

[Klatuu]

How are you capturing these criteria?
Are you saying you want them to appear in a text box on the report.
BTW, what you are describing is not a control source, it is a record source.
Reports and Forms have a record source property that defines the data. The
control source property belongs to controls. It defines which field in the
object's record source will be presented in the control.

Also, what version of Access are you using?