I am trying to add 2 tables via a query design.
The calculation in expression builder is this
LTL: [getOriginBeyond]![LTL] + [getDestinBeyond]![LTL]
The values on each of the above LTL sides is
16.1 and 14.36
The result I am getting in the results table is "16.114.36"
Hence this is being treated as a text addition
Since 'getOriginBeyond' data is being derived from another tabled called "ZONES", I went there and tried to change the 'Data Type' but it wouldn't let me change the data type :/
Any quick fixes to this?