Results 1 to 2 of 2
  1. #1
    ygu3 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    1

    Set Numbers equal to each other


    Hi, I'm in a bit of a jam here, hopefully someone knows how to do this or if it's even possible at all in Access 2003.

    I have a column of vendor codes, but multiple codes may refer to the same vendor (Ex: 10013 and 20013 may both refer to Vendor A). Is there any way to set 10013 and 20013 equal to each in Access, so that when I run a query for either 10013 or 20013 I'll pull up all vendors under both codes? Thanks for the help!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Not AFAIK but it is not too difficult to clean up the data with Access assuming you have some control over the data that is.

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

Similar Threads

  1. Dialing Phone Numbers From Access
    By obrmb in forum Forms
    Replies: 0
    Last Post: 06-11-2009, 12:35 PM
  2. Suming Positive Numbers Only
    By jbarrum in forum Access
    Replies: 5
    Last Post: 04-24-2009, 03:51 PM
  3. Non programer needs help in decimal numbers
    By Peter O in forum Access
    Replies: 1
    Last Post: 10-07-2008, 12:29 PM
  4. Insert Dash between set of Numbers
    By Jhankish in forum Programming
    Replies: 2
    Last Post: 04-19-2007, 08:02 AM
  5. When Week Numbers Collide!
    By Schwagr in forum Queries
    Replies: 3
    Last Post: 03-18-2006, 10:06 PM

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