Can I use IIF in a criteria expression?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top