Parameters in Blank Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I made a report that returns data based on two parameters - a [Begin Date] and an [End Date]. The parameters are in the criteria of a [Date] field like this: >=[Begin Date] And <=[End Date]. In my report header I have two text fields that also have [Begin Date] and [End Date] as the control source so that when rows are returned, the date range is printed on the report

However, when the query the report is based on returns no rows, the parameters are not passed to the text fields, and the text fields do not show the dates. Is there a way to capture the parameters and pass them on to the report so that even a blank report has the date range
 
Use a form to gather the parameters. Then se the conditions to reference
the form controls.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query In Report Title 3
Date Range in Header 1
Date Range in Header 1
How to display parameters on a report where the query returns no rows? 1
Using Form for Criteria for Report 3
print a date range from parameter query on a report header? 2
Parameter criteria in Report 4
Parameter Value as a Report Heading (Label/Text) 1

Back
Top