By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,329 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Complex Access Lookup Table Help

100+
P: 121
I am trying to see is there is a way to lookup and update a field based on matching part of the contents of a field to a lookup table.

Example.

I have an "Error Description" field. And it adds codes to the field based on some queries.

So the field would look like: ACC-1, ACC-3, EXP-1

I want to know if I can change those codes to actual descriptions based on a lookup table.

So it would look like this: Missing Date, Missing Description, Invalid Cost

Or do lookup tables only work in matching the entire field contents.


Thanks
Feb 22 '07 #1
Share this Question
Share on Google+
2 Replies


maxamis4
Expert 100+
P: 295
Have you tried using a like query. These seem to work very well for boolean logic. Like Examples Scroll towards the buttom to see the examples of like queries. Also please display the query you have now in order to be helped a little more.

thanks
Feb 22 '07 #2

100+
P: 121
Thanks for the help.

I'm not sure how the Like Statement would work. I get how it would help me to find the records that have a certain error code. But, I'm confused on how I would use it to update the contents of the field for each code match. Also, I'm not sure how I would use it to lookup the description in my lookup table.

Thanks in advance for anymore help.

Here is the current query I have, but it is only designed to match the entire contents of one field to the other in the Lookup table:

UPDATE [Error-Description LU] INNER JOIN [DLU-Input Table] ON [Error-Description LU].[Error-Code] = [DLU-Input Table].[Error-Code] SET [DLU-Input Table].[Error-Code] = [Error-Description LU].[Error-Description];


Thanks,
Feb 27 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.