One record calculation not working the other 168 perfect?
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?