Can I use IIF in a criteria expression?

B

Bryan

iff([eff date]<>[tran date], <[tran date], =[tran date])

I am trying to retrieve the most recent record(out of several) and sometimes
the eff date doesn't equal the tran date.
 
M

[MVP] S.Clark

Not like that, unfortunately.

When you state "out of several" it makes me think that you should be using a
GROUP BY with a MIN, but I can't get my head around it. Perhaps provide
some more info, and we'll see what we can do.
 
Top