Use pop up dialog to limits records in report

Topic

New Reply

I have a simple report (i.e. a list of orders details).
I need to allow users to choose the records displayed on the report.
I understand I could this by choosing a start and end range (say of the record id) from combo boxes on a pop up form. I’m sure this is simple but I just can’t figure out how to do it. Does anyone have a simple example.

Reply | Quote

Replies

I’d suggest basing the report on a parameter query that prompts the user for a beginning OrderID and an ending OrderID (or use whatever the actual field name is.) Place the prompts in brackets in the criteria field of the query like this:

Between [Enter The Beginning OrderID] And [Enter The Ending OrderID]

When the report is run it will generate two boxes asking for the IDs.

Reply | Quote

Thanks, I’ve tried tried this before.
My reason for asking the original question is I’m being asked to do some more advanced stuff and need to figure out how to build up a query based on selections the user makes from a form (i.e. they aren’t typing in values where a mistake could be made but selecting actual values that exist in the database. Any more suggestions?

Reply | Quote

use list boxes or combo boxes for choosing then
tie the query to the list or combo as the parameters for the query

Reply | Quote

I know this is what I need to do – I just know very little about queries full stop. I’m being asked to program before I know fully about databases. I’m looking for a simple example I could learn from.

Reply | Quote

Have you tried looking in the Solutions database for an example? Look under “Control what you print on reports.”

Or look in Northwind at the “Sales Reports Dialog” form.

Reply | Quote