Syntax problem

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I use the following expression to gather information on a form to show the
total for the customer to be paying including VAT.

=subfrmorderdetail.Form!OrderSubtotal+Val(cboDelRate.column(2))

Thats in the control source of the text box.

I have another field for informational purposes which needs to show the
amount of VAT payable of the above.

I have tried the following to only gather error in the control.

1)
=Sum(subfrmorderdetail.Form!OrderSubtotal+Val(cboDelRate.column(2))/100*17.5
)
2)=17.5%(subfrmorderdetail.Form!OrderSubtotal+Val(cboDelRate.column(2))

Please help me to sort out my Syntax.

Thanks in advance.

Rob
 
Rob

Let's say that the control holding this value;

=subfrmorderdetail.Form!OrderSubtotal+Val(cboDelRate.column(2))

is called tbSubTotal and your VAT control is called tbVAT and your Total Due
is called tbTotalDue

Then set the tbVAT controlsource to;

=[tbSubTotal] * 0.175

and the tbTotalDue to

=[tbSubTotal] + [tbVAT]

All controls are formatted as Currency

HTH

Andy
 
Back
Top