Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
MS Access Syntax Error
I'm using the following code and receiving Access error code:
SELECT
CASE
WHEN [tblConsolidated].[Appeal Category L3] IN
('180 MEDICAL INC',
'180 MEDICAL INC',
'180 Medical Inc.',
'180 Medical, Inc',
'180 MEDICAL, INC.')
THEN '180 MEDICAL INC'
Else [tblConsolidated].[Appeal Category L3];
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
As far as I know you can't use CASE WHEN in Access SQL, what you could try instead is an Iif statement.
Or perhap simpler.
Iif([tblConsolidated].[Appeal Category L3] IN ('180 MEDICAL INC', '180 MEDICAL INC', '180 Medical Inc.', '180 Medical, Inc', '180 MEDICAL, INC.'), '180 MEDICAL INC'
, [tblConsolidated].[Appeal Category L3])
Or perhap simpler.
IIf(UCase(Replace(Replace(Replace([tblConsolidated].[Appeal Category L3], ',', ''), '.', ''), ' ', '')) = '180MEDICALINC', '180 MEDICAL INC', [tblConsolidated].[Appeal Category L3])
Do you need all the checks?
See if this works:
SELECT ucase(replace(replace([App
See if this works:
SELECT ucase(replace(replace([App
>>receiving the following
Make sure you have the FROM in your select.
It worked for me:
Make sure you have the FROM in your select.
It worked for me:
SELECT Iif([tblConsolidated].[Appeal Category L3] IN ('180 MEDICAL INC', '180 MEDICAL INC', '180 Medical Inc.', '180 Medical, Inc', '180 MEDICAL, INC.'), '180 MEDICAL INC'
, [tblConsolidated].[Appeal Category L3])
from tblConsolidated
;
Premium Content
You need an Expert Office subscription to comment.Start Free Trial