Access always deducts $22.35 in a otherwise functioning calculated Field

[ChingghisKhan]

Hi,

I have a real weird problem:

1.) I Created a form: “PURCHASE DETAILS” - the controls on this form exist also on another form: “ORDER ENTRY”

2.) The entries that are on this new form will eventually be removed from the form: “ORDER ENTRY” – but only after I get everything working correctly.

3.) Since the calculated fields can’t pull the values like on the “ORDER ENTRY” form (because they are not on the table) I created a new Calculated Field, called: “PROFIT”

4.) The expression is: “([MSRP USD]+2000-[Discount:]+[Scope Price:]+[Mount Price:]-[Price we Paid:]-[Export Cost:]-[Transport Cost:]-[Import Cost:]-[Other Cost:]-[Commission:])”

5.) The calculation is correct in the 1000's and 100's, but the 10's and cents are ALWAYS wrong. Example: "PROFIT" on form "ORDER ENTRY" says $1,550.00, then the form “PURCHASE DETAILS” says $1,527.65. When I change the price by $1,500.00, the "PROFIT" field says $3,027.65. When I change the 10's, 1's and cents by $11.11, it says $3,038.76!

6.) On the other form: “Order Entry” the values are always correctly calculated, there the expression is: ([Final PRICE:]-[TOTAL COST:])


Can you please help?

Thanks

Robert

 

[Cronk]

Follow the data path.

You do not indicate where the data is coming from? You referred to copying controls, presumably text boxes. Are the data sources for these table values or coming from a query?

One method of debugging would be to create some text boxes with each one having one of the individual values in the formula.

 

[Simon_MT]

Check the correct calculations and see how they work. I would break your Expression up.

Does [MSRP USD]+2000 does this work for all scenarios?

SaleValue: [MSRP USD]+2000-([Scope Price:]+[Mount Price:])
PaidValue: [Price we Paid:]
OtherCosts: [Export Cost:]+[Transport Cost:]+[Import Cost:]+[Other Cost:]
Commission

Colons are not necessary in Expressions

Simon