Here is the SQL Switch statement I'm using: SELECT Process, TransactionsCompleted, Switch( Process ='SPRD100',TransactionsCompleted*2, Process ='SPRD500',TransactionsCompleted*3, Process ='SPRD750',TransactionsCompleted*5, ) AS calculatedcolumn FROM TBLSystemTransactions; (Process=Fruit, TransactionsCompleted = N) However, I'm still getting the compile error. Can you check the statement and see any errors? Thanks