G
Guest
I didn't really know how to explain my question briefly enough for the
subject, so I hope people understand my subject enough to click this thread
if they can help. I was able to remember the answer to my question from
yesterday, but now there is something else I want to do, and I wondered if
anybody knows how.
Currently, I have several queries that will be run using the data the user
gives in certain forms. Now, what I want to be able to do is to allow the
users to either leave one of the fields in the form blank, or select some
kind of "Select all" type of option, and that would then give them all of the
records based on their other parameters.
For example: I may want to give our users a form where they are able to
enter the first and last name of the employee they are searching for, and the
name of the instructor who taught their training course. The goal would be
that they'd enter the employee's name and the name of the instructor in
question, and the query would then find all of the courses that "Employee A"
took that were taught by "Instructor 1."
However, what I'd also want to do is to allow users to choose NOT to supply
an instructor, and thereby simply get ALL of the courses this employee took.
How could I achieve this? I have several other similar queries I'd need, but
I think if anybody can explain to me just how to do one, I'd be able to apply
that to the others. Thanks for any help anybody can provide.
--
Have a nice day!
~Paul
~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''''
ptaylor
subject, so I hope people understand my subject enough to click this thread
if they can help. I was able to remember the answer to my question from
yesterday, but now there is something else I want to do, and I wondered if
anybody knows how.
Currently, I have several queries that will be run using the data the user
gives in certain forms. Now, what I want to be able to do is to allow the
users to either leave one of the fields in the form blank, or select some
kind of "Select all" type of option, and that would then give them all of the
records based on their other parameters.
For example: I may want to give our users a form where they are able to
enter the first and last name of the employee they are searching for, and the
name of the instructor who taught their training course. The goal would be
that they'd enter the employee's name and the name of the instructor in
question, and the query would then find all of the courses that "Employee A"
took that were taught by "Instructor 1."
However, what I'd also want to do is to allow users to choose NOT to supply
an instructor, and thereby simply get ALL of the courses this employee took.
How could I achieve this? I have several other similar queries I'd need, but
I think if anybody can explain to me just how to do one, I'd be able to apply
that to the others. Thanks for any help anybody can provide.
--
Have a nice day!
~Paul
~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''''
ptaylor