search multple columns with individual criterion

N

Nat

I need a single record from one table to query a table of 150 records with
each record requiring a minimum value from 85 to 110, in at least 1 of 10
categories. the remaining categories have no relevance for the search and
can be left blank or overvalued.

Here's what I have:
a. Form with personal input, name and 10 scores received on a test.
b. Table (1) that stores above data.
c. Table where minimum scores are stored in 1 of the 10 score categories and
150 possible jobs based on these scores from table (1).

Output will be to screen and/or printer.
 

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