Setting a true or false value dependent on evaluation of 2 different fields.

[Benzer420]

I have a form based on a query. 3 of the fields are[CATEGORY], [BOATCLUB NO- AND [BOATCLUB JOINING FEE]. What I'm trying to achieve is to evaluate if [CATEGORY]="VB" OR [BOATCLUB NO] Is Not Null, Set the value to $0.00 or else set the value to $11.00.

Many Thanks
Benzer420

[CJ_London]

for an unbound control put the following in the controlsource

=iif([CATEGORY]="VB" OR not isnull([BOATCLUB NO]),0,11)

and format the control as currency

[Benzer420]

Many Thanks, works great. It was the last thing I was trying to achieve to finish this database and I'm afraid I had a mental block.