Would like query criteria to show up on report

  • Thread starter Thread starter CindyT
  • Start date Start date
C

CindyT

Is there a way to have the criteria from a query show up
on a report? For example if I run a query by using start
date and end date, is there a way to have the start date
and end date print on the report for future reference?
Thank you for any information you may provide.
 
Is there a way to have the criteria from a query show up
on a report? For example if I run a query by using start
date and end date, is there a way to have the start date
and end date print on the report for future reference?
Thank you for any information you may provide.
Click to expand...

If the query parameters is something like:
Between [Enter Start] and [Enter End]
then add an unbound control to the Report.
Set it's Control source to:
="For Sales between " & [Enter Start] & " and " & [Enter End]

The bracketed text must be identical to the bracketed text in the
query.
 
-----Original Message-----
Is there a way to have the criteria from a query show up
on a report? For example if I run a query by using start
date and end date, is there a way to have the start date
and end date print on the report for future reference?
Thank you for any information you may provide.
.
Click to expand...
Create a label on your report Header or wherever you want
to place it and give it the data source:

(="Sales From " & [Type The Beginning Date: (Format:
mm/dd/yy)] & "To " & [Type The Ending Date: (Format:
mm/dd/yy)])
 
Back
Top