acess employee database

[Help My job depends on it]

Name employer 1 employer 2 employer 3 employer 4 emloyer 5

I have a sheet in access with these headings ...

1 Can I construct a parameter box that pops up and allows me to querie up to
five names at a time

2 How would I construct a querie like that????

 

[Jeff Boyce]

If you have a table in Access with fields named "employer1", "employer2",
.... you have a spreadsheet, not a well-normalized relational database table.

Is there a reason you aren't doing this in, say, Excel?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Help My job depends on it" <Help My job depends on
(e-mail address removed)> wrote in message
news:[email protected]...

 

[John W. Vinson]

Name employer 1 employer 2 employer 3 employer 4 emloyer 5

I have a sheet in access with these headings ...

1 Can I construct a parameter box that pops up and allows me to querie up to
five names at a time

2 How would I construct a querie like that????

If your job depends on this... either get some hired help, or get some good
training.

Your table design IS WRONG. This is possibly ok for spreadsheets but Access
isn't a spreadsheet.

If each person has multiple employers, and each employer can hire multiple
people, you need THREE tables:

Employees
EmployeeID
LastName
FirstName
<other biographical info about the person>

Employers
EmployerID
EmployerName
<other info about the employer>

Employment
EmployeeID <link to Employees, who was working>
EmployerID <link to Employers, who they worked for>
<other info about this employement, e.g. date started & ended>

You can then use a Query with and IN clause to inquire about any number of
employers.