[AccessD] multiplications in one query

pedro at plex.nl pedro at plex.nl
Thu Oct 30 13:47:05 CST 2003


Hello Group,

i have a query with two fields: code and telling.
I would like to do some calculations with these fields. 
The calculations could be done in a query for each code, 
but i want to do all calculations in one query?


TIA

Pedro Janssen
Cytologist


i have.

code            telling
a                 1000
b                  500
c                  100


i want to multiply
a (1200)*0,3
b (500)*2
c (100)*7


as result i would like

code           Result_Telling
a                  300
b                 1000
c                  700


More information about the AccessD mailing list