Translations

[shubrook]

I'm new to access, and I suspect that there is a very simple answer to my problem:

I receive about a dozen reports from different companies, all of them in their own format. Up until now, I have been using excel's vlookup function to convert their codes unto my codes. For example, they might designate a value of RNWL which in our system is RWL.

I think I am supposed to be using the dlookup function - can't make it work, though. is there a simpler way to do it?

[alansidman]

Without detailed information, I am guessing, but it appears you should be using a select query to match up your data with your input. To do this you will need to create a table that aligns your code with the input code and use that in your query with the input data. Post back if you require more information -- but be sure to post more information about it, ie. actual field names, etc.

Alan