ORDER BY error when using DESC in an IIf

[Smitoris]

I have a query in which I use something to the effect of the following in the ORDER BY clause:

ORDER BY IIf((Element.Division = 4 or Element Division = 7), [Element.A] & [Element.B] & [Element.Z], [Element.D] & [Element.B] & [Element.Z])

I want the [Element.Z] to sort in descending order but when I add DESC after it Access is throwing an error.

Any idea how to make this work? Thanks in advance.

Neal

[June7]

You are missing the dot in the second Element.Division

[Smitoris]

I omitted the period on accident. I figured this out, though.

The issue is that you cannot sort DESC within a concatenation. I moved the last field to sort on outside of the IIf statement and it works.