Access Query Using ID number

[darinmc]

Hi
I have an employee table (having a maximum of 3 categories) joined to a table which holds different categories...
Eg id field
1 = Domestics
2 = Kitchen assistant
3 = Driver

Some people have 2 or 3 categoraries, I need to do a query, I have linked the 2 tables, how do i get the query to show:

Category1 Category2 Category3
It shows the Category name and not the id when i export it to excel..

The query now shows
name, surname, categoryID1,categoryID2,categoryID3,

I need to convert the categoryID to that corresponding field in the Category Table..

Thx


Darin

 

[dhookom]

Your table isn't normalized. However, you can join the 3 category fields in your employee to 3 copies of the category table. You might want to make sure the joins include all the records from the Employee table.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]