Access Ms Access


Joined
Mar 25, 2014
Messages
1
Reaction score
0
Can anyone help me out in this...?

I am writing iif function in access, its only returning me the false records.

IIf([Sheet1]![Actual Start]>=[Sheet1]![Plan Start], 100*0.2, 0)
or
IIf([Sheet1]![Actual Start]>=[Sheet1]![Plan Start], 1, 0)

in both the cases its returning the false records only. Where as I need all records.

Thanks in advance:bow:
Abdul
 
Ad

Advertisements


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

Top