Access Ms Access

M

mamatheen

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
 

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

Access Access Reporting 1
Excel How to get output of the formula instead of True or false 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
Access Tricky IIF statement in Access - Grrrr 2
Excel Export Filtered Form Data To Excel 0
Outlook SAGE 50 Cloud Accounts & Outlook 365 not talking to each other anymore ....! 0
How to export table from outlook into ms access table? 0

Top