Kindly help me write an expression in my MS ACCESS report

vinodnair

I think you'll be ahead creating the calculated fields in the query that provides records to the report, rather than relying on calculations in controls on the report itself.

That said, you refer to default control names on the report (e.g. [Text45], etc.). Those names add a layer of ambiguity to the discussion, so renaming them to reflect their actual contents would be really helpful going forward. 

Also, it looks like you have a value list for Units somewhere. It's probably more efficient to create a look up table of UOM with a Primary Key and two value fields, one for FullName and one for Abbreviation. That way you can add the lookup field to the query for the report and just retrieve the appropriate values (full or short) for the controls on the report.

The same is true for the conversion to KG from GM. Do that in a calculated field in the query and simply return one field to the report with the appropriate value already available.

Sometimes we have to step back and rethink the process to see where we can gain efficiency by pushing values down into the underlying source; in this case the query.