changing value from another table

[nkiefer]

I have a main table with a field containing coded values, a,b,c etc...

I have a seperate table that has two colums the code and code value,
code value
a 1
b 2
c 3

Is it possible to create a query that displays the values, 1,2 or 3 instead of a,b or c?

 

[dhookom]

Yes, just add both tables to your query and join the a,b,c fields. You can then display the related value in the query.

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]