Results 1 to 2 of 2
  1. #1
    shubrook is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    1

    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?

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    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

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums