SQL Syntax Error(missing operator) Microsoft Access in Case Statement

higgins 0
Viewed 48

I am working on a SQL query but cannot get started in the following case statement because I keep running into this error. The current query looks like this:

SELECT CoupaData.PO, CoupaData.Line, CoupaData.[Work Order #], CoupaData.Item, CoupaData.LineTotal,
       CoupaData.Received, CoupaData.ApprovedInvoiced, CoupaData.[Line Status], 
       (CASE 
          WHEN CoupaData.LineTotal = CoupaData.Received THEN 'YES'
          ELSE 'NO'
        END) AS gg
FROM CoupaData;
case ms-access sql
1 Answers

Case statements aren't allowed in JET SQL. Try the inline if statement. You can nest these as well if you have multiple conditions.

    SELECT 
     CoupaData.PO
    , CoupaData.Line
    , CoupaData.[Work Order #]
    , CoupaData.Item
    , CoupaData.LineTotal
    , CoupaData.Received
    , CoupaData.ApprovedInvoiced
    , CoupaData.[Line Status]
    , IIf(CoupaData.LineTotal = CoupaData.Received, 'YES', 'NO') AS gg
    FROM CoupaData;
Vlookup0
Related