Update Query Help

[davec69]

In my table, I have a column named "category". The data imported into this column, was previously entered as abbreviations, ie. acces, impor,dom,ect. I would like to create a query to convert the data in this coulmn, to the actual full name, ie. Accessories, Imports, Domestic, ect. I've created a new table, with the abbreviation in one column, and it's corresponding full description in a second column. How do I setup a query to use the information in this second table? I realize that simple find and replace would do what I want, but new data is added to the table daily, and a query seems like the best way.

 

[EMP]

You can join the two tables in a query.

The attached sample database contains two queries: one with an inner join, the other an outer join.

 

[dcx693]

Perhaps you should run an update query to fix the existing data and have your user(s) use a form to properly enter new data into the table. It's perhaps a better long-term solution than having a 2nd table out there, but it's up to you.

 

[davec69]

I didn't explain the situation fully. The data in this table is imported daily from our Accounting/Ordering system. The field in that external application only allows 5 character spaces for input. We use Access as our online/web backend. I'll give EMP's suggestion a try, and post the results. Thanks for your response, though.

 

[davec69]

Well, I don't understand the concept of inner vs outer joins, but I was able to get the query to do what I wanted. Thanks much, for the help.