The total of multiplication error

[cheekybuddha]

Try it like this:

=[LineTotal]+(CLng([LineTotal]*[SalesTaxRate]*100/100))+[FreightCharge]

 

[cheekybuddha]

Or with the idea of Arnel's previous fix:

=[LineTotal]+(CLng([LineTotal])*CLng([SalesTaxRate])*100)/100+[FreightCharge]

 

[arnelgp]

[LineTotal]+(CLng([LineTotal])*CLng([SalesTaxRate])*100/100)+[FreightCharge]

putting the above on a query does not produce any errors.

 

[The_Doc_Man]

I don't know that I have EVER seen a "too many ()" error, but as long as they are properly balanced, you can have a LOT of nested parentheses. In SQL queries, if you use the grid-based query designer, you automatically get what I think of as "too many parentheses" but SQL still takes it. In VBA expressions, I've used several layers of parentheses as well.

Can you make a screenshot of the error you are actually getting?

 

[7anthala]

This is the error