Complex Question


G

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
 
Ad

Advertisements


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


Top