Report Headings

[rhernand]

I have a report based on a query. This query has a BETWEEN [ENTER STARTING NUMBER] AND [ENTER END NUMBER] as criteria for the NUMBER field. I want to include the [ENTER STARTING NUMBER] and [ENTER END NUMBER] data in my report. How and I capture these. The report heading will be as such:
NUMBER Report
From [ENTER STARTING NUMBER] to [ENTER END

NUMBER]

 

[Pat Hartman]

You'll be happier if you use a form to gather parameters rather than prompting. You can then reference the form fields in the report header to get the parameter values. Otherwise, just include the prompt fields in the select clause.

Select [ENTER STARTING NUMBER] as StartingNumber, [ENTER END NUMBER] As EndingNumber, fld1, fld2, etc
From YourTable
where SomeNumber Between [ENTER STARTING NUMBER] and [ENTER END NUMBER];

Make sure that both references to each parameter are IDENTICAL otherwise you'll get extra prompts.

 

[rhernand]

Worked great, thanks