Query Field Calculation

[wazza]

hi all

I would like to perform a query on several tables. The table has a field which contains a sales value.

I would like to query this data and multiply or divide the sales value against another field (conversion factor) from a different table.

Creating an extra field in the query - the calculated field!

Im sure this is possible... do i have to build some sort of expression - ive tried but i dont think im getting the syntax correct..

 

[maxmangion]

yes you can create the extra field with the expression in it. the syntax should be as follows:

expr1: [tablename].[fieldname]*[tablename].[fieldname]

where expr1 can be any valid name for your calculated field. Also you should replace the * with / if you would like to divide.

 

[gbshahaq]

TIP:
use the expression builder wizard....

Sham

 

[wazza]

thanks very much..