Syntax error - please help a newbie

[pcc]

I am very new to Access and SQL. I have this code in a query, but when I try to save the query, I get a 'syntax error (missing operator)' message.
All of the field and table names are OK, so what have I missed?

SELECT s.PrjDef, s.PrjType, s.ActType, s.CCntr, s.Hours, s.yr, s.ap, s.inorsub = 
CASE 
WHEN s.inorsub = 'I' then 'Inhouse' 
ELSE  'Subcon' 
END 
FROM sapsummary AS s WHERE 1=1 ;

 

[anvil19]

Hi pcc

Access SQL does not support CASE expressions. You will need to determine variables outside of the SQL statement.

Also, as far as I am aware, your FROM TableName AS ?? is not supported in Access SQL. You must qualify the fields before the FROM bit (sapsummary.PrjDef, etc.).

anvil19

 

[pcc]

Thanks for reply. I think you are right regarding the CASE statement so I am looking at other ways (SWITCH function maybe?). With regard to the second point, the tablename AS statement seems to work OK for me so I'll stick with it.
Thanks for your time.
Cheers