Multipal parameters input

J

Jacqueline

I want to create a report that will be run with a parameter query in the back
ground where my users (students) can click a button and input several course
numbers that will then run a report for each course as a check-off sheet.

I have everything build, except the multipal input ability. A parameter
query will allow a maximum of two inputs for the course field. Any
suggestions, am I doing this the hard way is there a better way?
Thanks much,
 
G

ghetto_banjo

Depending on how many course numbers are available, you could have a
form setup that has a list box where students can select MULTIPLE
items in the list and base your query off of that.
 
A

Armen Stein

I want to create a report that will be run with a parameter query in the back
ground where my users (students) can click a button and input several course
numbers that will then run a report for each course as a check-off sheet.

I have everything build, except the multipal input ability. A parameter
query will allow a maximum of two inputs for the course field. Any
suggestions, am I doing this the hard way is there a better way?
Thanks much,

If you want to try some VBA coding, you can have your report display a
form to prompt for criteria. I have an example "Report Selection
Techniques" at www.JStreetTech.com/downloads that you can take a look
at.

If your users know the course numbers already, you could just have
them enter them into a text field separated by commas. Then you could
use that field to build a SQL IN clause in code:

Where CourseNumber IN (1234, 1235, 1236)

If you need to allow them to pick courses from a list, things get more
complex. You could use a local work table to store the selected
courses, bound to a continuous form that allows the students to add
all the desired courses using a combobox. If this is a multi-user
application, this approach requires that you've split the database and
that each user has their own copy of the front-end.

Hope this helps,

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 

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

Top