[mso] Re: Multiple Choices in Access

Paste this into SQL view it will return the records you want, without record
501 SALS. 

Change the name of the table from Table1 to the name of your table. 

SELECT ID, CODE1 AS Final_Code
FROM Table1
WHERE CODE1 like 'salj'
UNION SELECT ID,CODE2 AS Final_Code
FROM Table1
WHERE CODE2 like 'salj'


*************************************************************
PLEASE READ!!!!

This is not S*P*A*M!  You are receiving this mail because you either subscribed 
to mso@xxxxxxxxxxxxx or to it's earlier version, 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with 
a subject line that says "unsubscribe" (without the quotes).  Do not put 
unsubscribe IN CAPS.  Screaming doesn't get you out any faster and the caps 
prevent the function from working.

To change your email settings to digest or vacation (no mail), visit the 
group's homepage for full instructions.

http://www.freelists.org/webpage/mso
*************************************************************

Other related posts: