Parameters

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

Guest

Hello~

I need help. My user would like a report that can have one user, all users, or only the users she selects. I can do the one user and all users just fine using parameters. I don't know how to have it set up so she selects whatever users she wants from the form, pushes a button, and the report is produced. I thought you could put an "OR" statment in a parameter but you can't. Any ideas how to do this?????? I would greatly appreciate it. Thank you.

Angela
 
you can put an OR statement in a query's criteria field. What does the form
look like where she is entering the criteria?

Rick B


Hello~

I need help. My user would like a report that can have one user, all users,
or only the users she selects. I can do the one user and all users just
fine using parameters. I don't know how to have it set up so she selects
whatever users she wants from the form, pushes a button, and the report is
produced. I thought you could put an "OR" statment in a parameter but you
can't. Any ideas how to do this?????? I would greatly appreciate it.
Thank you.

Angela
 
Yes, I know you can in the or field. I don't have the form set up right yet. I have tried adding all the users she selects to a text box and then sending that to a query so only those users are used in the query but that didn't work because I had to put the or statement in. I hope that makes sense...i am just stumped.
 
You still have not told me how the form is set up. Are there a bunch of
users listed with checkboxes next to the? Is she using a multi-select
combobox? Are there numerous fields where she enters one user per field?
Or is there one large freeform field where she types in multiple userids?

Rick B


Yes, I know you can in the or field. I don't have the form set up right
yet. I have tried adding all the users she selects to a text box and then
sending that to a query so only those users are used in the query but that
didn't work because I had to put the or statement in. I hope that makes
sense...i am just stumped.
 
I need help. My user would like a report that can have one user, all users, or
Click to expand...
only the users she selects. I can do the one user and all users just fine using
parameters. I don't know how to have it set up so she selects whatever users she
wants from the form, pushes a button, and the report is produced. I thought you
could put an "OR" statment in a parameter but you can't. Any ideas how to do
this?????? I would greatly appreciate it. Thank you.Hi Angela,

I use this method a lot and my users really love it.

Access Archon Column #72 -- Paired Multi-Select Listboxes
By Helen Feddema - the Access Archon
http://www.helenfeddema.com/access.htm

Good luck,

Gary Walter
 
Back
Top