Parameter Report Question

  • Thread starter Thread starter Antavas
  • Start date Start date
A

Antavas

When I create a report based off of a parameter query is it possible for the
report to list the criteria that was picked? For instance I have a report
that shows month, State, Region but it also shows if the item has been sold
or is in stock. My parameter query prompts you to enter the Month, the State,
the region, and indicate if the item is in stock or sold. However the report
does not show the In stock or Sold field. But can a summary page of the
criteria entered be created?
 
An alternative is to use a calculated field.
If your criteria is --
Between [Enter start] And [Enter end]
Then copy to make sure of not having typo errors to new field in
design view grid like this ---
Start: [Enter start] End: [Enter end]

--
KARL DEWEY
Build a little - Test a little


John said:
When I create a report based off of a parameter query is it possible for the
report to list the criteria that was picked? For instance I have a report
that shows month, State, Region but it also shows if the item has been sold
or is in stock. My parameter query prompts you to enter the Month, the State,
the region, and indicate if the item is in stock or sold. However the report
does not show the In stock or Sold field. But can a summary page of the
criteria entered be created?
Click to expand...

Easiest way I know of is to create a Print Menu Form, with as many
text or list boxes as need to enter or select appropriate parameters

Then use those parameters to feed the criteria in a query AND to
enter the information into boxes on the report

For example, a date selection criteria in a query is
[forms]![PrintMain]![PickDate]

That same [forms]![PrintMain]![PickDate] is then used to
fill a box on the report to see the date that was selected
Click to expand...
 
Antavas said:
When I create a report based off of a parameter query is it possible for the
report to list the criteria that was picked? For instance I have a report
that shows month, State, Region but it also shows if the item has been sold
or is in stock. My parameter query prompts you to enter the Month, the State,
the region, and indicate if the item is in stock or sold. However the report
does not show the In stock or Sold field. But can a summary page of the
criteria entered be created?
Click to expand...


You can use the exact same prompt strings in the report as
if it were a field in the query. E.g. you could use a
report text box with an expression like:
="Dates between " & [Enter Start Date] & " and " & {Enter
End Date"
 
Back
Top