query entered
MS interprets and CHANGES this to:
Which incorrectly wants an input param value instead of the literal string
Does this mean Access doesn't accept simple compound/nested iif statements? ... is there anther way to do this inline without resorting to a UDF?
Code:
SELECT
Schedule.*,
[Work Orders].Jobdescription,
[Work Orders].Schedulecomment,
[Work Orders].Customeritems,
[Work Orders].InvoiceDate,
[Work Orders].Invoicenumber,
IIf(Not IsNull([Work Orders].invoicenumber)=True,”Invoiced”,
IIf([Work Orders].Completed=True,"Completed",Schedule.JobStatus)) AS Status
FROM Schedule LEFT JOIN [Work Orders]
ON Schedule.workorder = [Work Orders].[WorkOrder#];
MS interprets and CHANGES this to:
Code:
SELECT
Schedule.*,
[Work Orders].Jobdescription,
[Work Orders].Schedulecomment,
[Work Orders].Customeritems,
[Work Orders].InvoiceDate,
[Work Orders].Invoicenumber,
IIf(Not IsNull([Work Orders].invoicenumber)=True,[”Invoiced”],
IIf([Work Orders].Completed=True,"Completed",Schedule.JobStatus)) AS Status
FROM Schedule LEFT JOIN [Work Orders]
ON Schedule.workorder = [Work Orders].[WorkOrder#];
Which incorrectly wants an input param value instead of the literal string
Does this mean Access doesn't accept simple compound/nested iif statements? ... is there anther way to do this inline without resorting to a UDF?