Query to stop rounding off currency

[Ruegen]

Hi,



I have one field (table) with price and I have added the current GST (percentage) from another table and field.

In the query I have made a query field "total" and entered the formula.

Price is with Currency - dollar and GST is Currency - percent in their table with 2 decimal each.

I want the price to round have 10% added to it so $4.40 added with % however I am getting $4.50 - a round down.

The total is in currency format (query field properties).

I'm assuming it's just adding the unit 10 and then adding it instead of calculating it as a percentage...?

I've also added currency to the price properties in the query and percentage to the gst in the query without much affect.
Function so far.

Total: IIf([GSTCheckBox]=True,[CostPriceExGST]+[GSTPercent],Val([CostPriceExGST]))

What am I doing wrong here....

[pbaldy]

Your math is wrong. It would be

cost + (cost * GST)

[Ruegen]

Solved. I did this and it gets me the result I need.

Total: IIf([GSTCheckBox]=True,[CostPriceExGST]+[GSTPercent]+[CostPriceExGST],Val([CostPriceExGST]))

[pbaldy]

Really? That would yield

4.40 + .10 + 4.40 = 8.90

That's the correct result?

[Ruegen]

Really? That would yield

4.40 + .10 + 4.40 = 8.90

That's the correct result?

Correct - normally your formula is the correct one - however my foruma first gets 10% then I add that 10% to the original price and it gets me the 10% plus the original = result I want.

I wanted to have the user add a percentage in a field on a form. Since I don't know what that percentage will be until the user decides I have to calculate fields only.

I will use your forumla next time though!