-
Translations
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?
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules