I'm pretty much a beginner using Access (you've been warned) I have a query which takes an entry "Weight" measured in lbs and calculates the kg equivalent. This answer - kg- has 4 decimal points, so I set the format properties to 2 decimal points. This works well. Now the problem is that I have to display the amounts in a report as - kg/Weight. I have used the following so as not to have a "/" if there is no value:
IIf([Weight] Is Not Null,[kg] & "/" & [Weight]," ")
This works except for the fact that the kg value is carried out to 4 decimals not the 2 that I need. Is there something I can do to change this?
**the conversion factor is carried to 4 decimal places - we need that accuracy for the calculation.
Thanks!