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!