allow the user to customize the logic?

  • Thread starter Thread starter Dave Bernarducci
  • Start date Start date
D

Dave Bernarducci

I have a database that I need to develop queries for.

I have a table of people with, among other things,
a "location" field. The locations come from a "location
table" which has an ID key and the name of each location.
The table also has some checkboxes that indicate whether
this person has experience with a particular item.

I'd like to develop a query and associated form to allow a
user to retreive the names of all people in a particular
location who have specific experience.
I'd like them to be able to open a form and select the
location from a list and then check the boxes on the
experience they are looking for and have those records
displayed.
I'd also like to provide the capability to select multiple
locations or ANY location.

For example, all people in NY who have experience with
tool-a and tool-b. All people in NY or NJ who have
experience with tool-a.

Is this going to be possible with the GUI or will I be
diving into SQL? I need some help getting started and
can't find any examples to base this on.

thanks!!
Dave
 
On my website are several small sample databases that allows user input into
the query. They are:

CreateQueries2.mdb, CreateQueries3.mdb, CreateQueries4.mdb, and
CreateQueries5.mdb

They become progessively more sophisticated, so you'll want to start with 2
and work up.
 
thanks!
-----Original Message-----
On my website are several small sample databases that allows user input into
the query. They are:

CreateQueries2.mdb, CreateQueries3.mdb, CreateQueries4.mdb, and
CreateQueries5.mdb

They become progessively more sophisticated, so you'll want to start with 2
and work up.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org





.
Click to expand...
 
Back
Top