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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

...cannot use a calculated field in a Where clause... 2
Group By error message 2
Query Criteria 2
Normalizing Vendor Names 1
Type Mismatch in Expression with text fields 6
Query out transactions Continued.. 4
Query returning duplicate entries 2
Need help with a report......do I need a subreport? 3

Back
Top