Truble with Date in Query and IIF

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.
 

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

MS Project. Real progress of the project, % complete 1
Need some PWA help 0
Rounding Problem 12
IIF in Crosstab Expression 0
How to use/create code in MS Word to calculate age? 0
Is there no "AND" function in Access like in Excel? 2
Create a status designation from 5 date fields using "Not IsNull" 10
excluding 12:00:00 AM from query results 4

Top