AnsweredAssumed Answered

One record calculation not working the other 168 perfect?

Question asked by EwanMacGregor on Nov 11, 2013
Latest reply on Nov 11, 2013 by EwanMacGregor

Title

One record calculation not working the other 168 perfect?

Post

     I am creating a simple product database. I have one table that consists of the product, part numbers etc and a cost price. This is shown as a number. I also have a country field which is a Value field. I also have a table of exchange rate and freight and duty. In the main product table I perform a calculation. When I select the country the currency, exchange rate and freight and duty multiplier are automatically added. I them perform a calculation to get the landed cost chichi is the cost x freight and duty multiplier divided by the exchange rate. It works perfectly apart from on two products that show a landed cost of £0.00. All other calculations are correct. I have tried adding new products as a test and these also result in a £0 landed cost.

     I'm going round the bend slowly. Has anyone got any suggestions where to look to get all fields to perform this calculation for all records?

Outcomes