Adding 2 tables via Query Design

Hi there,

I am trying to add 2 tables via a query design.

The calculation in expression builder is this

LTL: [getOriginBeyond]![LTL] + [getDestinBeyond]![LTL]

Open in new window


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?

Thanks!


LVL 13
Shanan212Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Michael VasilevskyConnect With a Mentor Solutions ArchitectCommented:
LTL: Cdbl([getOriginBeyond]![LTL]) + Cdbl([getDestinBeyond]![LTL])

0
 
Patrick MatthewsCommented:
If those are both currently text:

LTL: Val([getOriginBeyond]![LTL]) + Val([getDestinBeyond]![LTL])

Open in new window


0
 
Michael VasilevskySolutions ArchitectCommented:
Cdbl() converts the data in your field to the double (number) data type and they should add as expected then
0
 
Shanan212Author Commented:
wow! Nice! Thank you and have a great weekend!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.