HELP HELP HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[TehSparrow via AccessMonster.com]

I Have included all otehr required formulae for task 4 (e) but i cant get
this one to work. The Code looks correct so im a little lost!

Outstanding Funds: IIf([Paid]="Yes","N/A",[Cost])

Paid Field is a yes/no tickbox, and cost is a field that holds how much the
esson will cost. Im good with IF Statements in Excel, but this doesnt make
the same logical sense!

Any help will be greatly Received!!!!!

Cheers

Sparrow

 

[Keith Wilby]

I Have included all otehr required formulae for task 4 (e) but i cant get
this one to work. The Code looks correct so im a little lost!

Outstanding Funds: IIf([Paid]="Yes","N/A",[Cost])

Paid Field is a yes/no tickbox, and cost is a field that holds how much
the
esson will cost. Im good with IF Statements in Excel, but this doesnt make
the same logical sense!

Any help will be greatly Received!!!!!

Try IIf([Paid] = -1,"N/A",[Cost])

Keith.
www.keithwilby.com

 

[TehSparrow via AccessMonster.com]

Thankyou Keith =D

 

[Keith Wilby]

Thankyou Keith =D

You're welcome. For yes/no fields, -1 = "Yes" and 0 = "No".

Keith.

 

[Douglas J Steele]

You're welcome. For yes/no fields, -1 = "Yes" and 0 = "No".

You can also use the intrinsic constants True and False (not in quotes)