Help with performing a calculation on a form

[qad122]

On a mainform for a Sales Order, I calculate the Subtotal, Shipping Costs and Tax.

For the shipping costs, I have a code that states if there is no shipping, do not make shipping costs visible. However, it still charges for shipping.

Any ideas on how to write a statement saying to NOT calculate shipping into the Total.

Thanks,

Susan

 

[Darrylles]

Hiya qad,

May be an idea to specify EXACTLY how you are making the calualation and where.
In a query, in VBA etc?

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[qad122]

Hey Darrylle,

I have the following on the footer of a form:

SubTotal = frmsalelineitemsubform.Form!SubTotal

Shipping Costs = [SubTotal]*0.1065

Tax = [SubTotal]*.065

Total Due = [SubTotal]+[Tax]+[Shipping Costs]
Everything works great, when I have shipping costs. However, I have a check box with a code, that makes any relation to shipping not visible if shipping is not utilized. However, I still am getting shipping charges.

Hope this helps, as I am a novice.

-Susan

 

[Darrylles]

Hi,

You need:
iif(checkbox,Shipping Costs = [SubTotal]*0.1065,0) or
iif(checkbox=true,Shipping Costs = [SubTotal]*0.1065,0)

or something like that, which says if checkbox is checked then calculate or else insert zero.

(No Access expert here).
Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[qad122]

Darrylle,

Thank you! It worked...and I am smiling!

-Susan