I'm using the following code and receiving Access error code:
SELECTCASE 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];
As far as I know you can't use CASE WHEN in Access SQL, what you could try instead is an Iif statement.
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])
Open in new window
Or perhap simpler.
Open in new window