Query Help

[mugman17]

I am trying to build a query based on 2 tables/forms.

My first form "Companies", has 2 check boxes. One for Canadian Currency, one for US Currency. These are automatically sent to another form where the transactions are done.

On this other transaction form. There are 2 more checkboxes for the same thing. These are used to override the automatic ones. (ie. a company that normally deals in Canadian, deals in US for this transaction)

I am now creating invoices based on currency. I need to be able to see if the overide buttons are null or not, before using the automatic rates. Hopefully this makes sense.

Thanks in advance.

 

[Jack Cowley]

I little unsure how you have your tables set up but one way to check would be to use an Immediate If statement in your query along the lines of:

IIF(MyCheckbox = -1, SpecialRate, AutomaticRate)