Truble with Date in Query and IIF

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

I'm still having a problem trying to use a date in a query where there's an
IIF column.

This is what I have:

90Amt: IIf([TransDate]<#5/1/2010#,[Debit],0) and it doesn't work. Not
sure, but Dick told me I should use format for the date, but I don't know
how to do that in an IIF or if that is the problem.

Thanks for your help.

I really appreciate it.
 
Back
Top