Can I use IIF inside IIF?

[Minnow]

I have a query using an IIF clause, it works fine. But when I add another IIF
inside, it tells me syntax error. Any idea? The SQL code is as bellow:
SELECT A.[Customer ID], A.[Year], A.[Month], a.reading, iif( A.Unit='L',
IIF(A.Note=‘New Count’, A.[Reading], A.[Reading]-B.[Reading]),
HourToLiter(A.[Reading]-B.[Reading])) AS mProcessed
FROM [Monthly Reading] AS A INNER JOIN [Monthly Reading] AS B ON
(A.[Customer ID] = B.[Customer ID]) AND (A.[Year]*12 + A.Month -1 =
B.[Year]*12 + B.Month)
ORDER BY A.[Customer ID], a.Month;


Thanks for all consideration.

 

[[MVP] S.Clark]

Is HourToLiter() defined as a Global Function?

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[JohnFol]

Might be worth breaking it down to see if the nesting or the statement
causes the problem, ie:

Select
iif( A.Unit='L', "Unit = L" , HourToLiter(A.[Reading]-B.[Reading]),
IIF(A.Note='New Count', A.[Reading], A.[Reading]-B.[Reading]),
.......