Query - Report Question

  • Thread starter Thread starter Paul Axelrod
  • Start date Start date
P

Paul Axelrod

I am doing a report, based on a parameter query. Using between__and
as a criteria for the query, the user puts in a start and finish date
and the report is created.
Question is, how can I get the dates, Start and Finish into the
report.

Thanks
 
I am doing a report, based on a parameter query. Using between__and
as a criteria for the query, the user puts in a start and finish date
and the report is created.
Question is, how can I get the dates, Start and Finish into the
report.

Thanks
Click to expand...

Add an unbound control to the Report Header.
Set it's Control Source to:
= "For sales between " & [Start] & " and " & [Finish]

The text within the brackets must be identical to the bracketed text
in the query.
 
Fabulous, so easy when you know how.
Thank you.

fredg said:
I am doing a report, based on a parameter query. Using between__and
as a criteria for the query, the user puts in a start and finish date
and the report is created.
Question is, how can I get the dates, Start and Finish into the
report.

Thanks
Click to expand...

Add an unbound control to the Report Header.
Set it's Control Source to:
= "For sales between " & [Start] & " and " & [Finish]

The text within the brackets must be identical to the bracketed text
in the query.
Click to expand...
 
-----Original Message-----
I am doing a report, based on a parameter query. Using between__and
as a criteria for the query, the user puts in a start and finish date
and the report is created.
Question is, how can I get the dates, Start and Finish into the
report.

Thanks
.
Click to expand...


Hi Paul,
If I got the point of your problem the solution is very
easy.

You should insert two textbox into your report and write
for "Control source" item:

=forms!myFormDialogName!BeginningDate
and into second textbox
=forms!myFormDialogName!EndingDate

and that's all.

It is not bad idea to see reports from Northwind.mdb
sample database which goes with Office CD and you will
find a saple code behind reports that will help you.

Regards
Miki Stamenkovic,Belgrade
 
Back
Top