Querying a specific record.

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

Guest

I have set up a database for my work that keeps records of outstanding work
for performance consultants, part of which includes a skills exchange. I want
to set-up a query so that when I input the specific area of work outstanding
and save the record, a query will run telling the user which ofice members on
the database have those skills.

The skills will be input by name of staff member and a look-up box used in
the main record so you can choose a skill that exists.
 
I have set up a database for my work that keeps records of outstanding work
for performance consultants, part of which includes a skills exchange. I want
to set-up a query so that when I input the specific area of work outstanding
and save the record, a query will run telling the user which ofice members on
the database have those skills.

The skills will be input by name of staff member and a look-up box used in
the main record so you can choose a skill that exists.
Click to expand...

A simple Parameter query with a criterion such as

[Enter skill:]

or better, a reference to an unbound Combo Box on a form:

[Forms]![formname]![cboSkills]

should work... depending on the structure of your tables. What do you
mean by "the main record"? If you're not already doing so I'd
recommend a structure with three tables:

Employees
EmployeeID
LastName
FirstName
<other bio data>

Skills
Skill <Text, Primary Key>

EmployeeSkills
EmployeeID
Skill
<maybe other fields, e.g. level of expertise>

A Query joining EmployeeSkills to Employee, with a criterion like that
above, should do the trick.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top