I have the following script that works in Access but not in sql. I trying to replace the the value in the field "RSAMSTORE" with another value I give it (i.e. 999994, etc.) when the data is displayed. In otherwords when the select distinct is ran instead of seeing the value in the table "RSAMSTORE" I will see the substituted value "999994" Unfortunately I'm getting syntax error. thank you.
SQL Script sample:
SELECT DISTINCTROW IIf([sub2group]='RSAMSTORE','999994',IIf([sub2group]='RNEWSTORE','999995',