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
Abdul
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
Abdul