Complex Question

[Guest]

I have 3 fields
Hotel_Amount
Credit_Card_Amount
Cash_Amount

and 3 Check boxes
CTA
Direct Bill
Personal Credit Card

Okay this is where is get confusing
If CTA is checked or Hotel_Amount (has a value in it) Credit_Card Amount
needs to return 0.00
If Direct Bill is Checked and Credit Card Amount (has a value) then
Hotel_Amount needs to return 0.00
I want to add three fields into my query for these expressions
I want them to be called

Cash
Charge
Hotel
When i run my query they either need the amount I typed in under my table or
be 0.00
I hope this make sense.
Thanks
Chey

 

[tina]

take a look at the IIf Function topic in MS Access Help.

hth