T
toby131
I have a query in access where I use SQL code to calculate a field. In the
SQL code I have a series of if statments that use * to represent any
character and # to represent any number. The query outputs the correct
results in Access. When I import this to excel, it does not correctly
interpret the * or #, so outputs my "then" from the if statement. Is there
somewhere in Excel 2003 that I can change the language it is using to
recognize the * & #?
For clarification, here is an example:
IIf([Type] like "8##*, "800", "x")
Results in Access
Type Result
825XY 800
650ZX x
875YX 800
Results I am getting in Excel
Type Result
825XY x
650ZX x
875YX x
Thanks!
SQL code I have a series of if statments that use * to represent any
character and # to represent any number. The query outputs the correct
results in Access. When I import this to excel, it does not correctly
interpret the * or #, so outputs my "then" from the if statement. Is there
somewhere in Excel 2003 that I can change the language it is using to
recognize the * & #?
For clarification, here is an example:
IIf([Type] like "8##*, "800", "x")
Results in Access
Type Result
825XY 800
650ZX x
875YX 800
Results I am getting in Excel
Type Result
825XY x
650ZX x
875YX x
Thanks!