njellis
IS-IT--Management
- Jul 17, 2006
- 29
I am trying to run a query in which ColA + ColB = ColC
ColA has a specified value (I.e. any number)
ColB (the problem) is from a dropdown list which is pulled from another table (TripCharge).
Info for the table (TripCharge). 2 Colums
PriKey | Value
0 $0
1 $10
2 $20
ColB in the Query SHOWS the correct value. But the math does not calculate correctly. Somehow the computer is adding the PrimaryKey not the Value.
Example of what I'm getting:
ColA ($3) + ColB ($10) = ColC ($4)
As you can see For ColB it's adding the PrimaryKey (1) instead of $10. Again note it is SHOWING $10 in ColB but isn't adding $10.
What I WANT is:
ColA ($3) + ColB ($10) = ColC ($13).
Thank you for any help you can provide. This is Access 2010. =)
I'm not sure if I need to somehow convert ColB into a value then do the calculation or if I've just got something setup wrong.
ColA has a specified value (I.e. any number)
ColB (the problem) is from a dropdown list which is pulled from another table (TripCharge).
Info for the table (TripCharge). 2 Colums
PriKey | Value
0 $0
1 $10
2 $20
ColB in the Query SHOWS the correct value. But the math does not calculate correctly. Somehow the computer is adding the PrimaryKey not the Value.
Example of what I'm getting:
ColA ($3) + ColB ($10) = ColC ($4)
As you can see For ColB it's adding the PrimaryKey (1) instead of $10. Again note it is SHOWING $10 in ColB but isn't adding $10.
What I WANT is:
ColA ($3) + ColB ($10) = ColC ($13).
Thank you for any help you can provide. This is Access 2010. =)
I'm not sure if I need to somehow convert ColB into a value then do the calculation or if I've just got something setup wrong.