Adding then Multiplying in one expression

T

TKM

I need to get the results from:
[BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT] and then add those
results to: [CMPSOWNER_FUNDDESC].[FD_DESC_CD]

Would this work? It seems I am getting different results then what I am
looking for.

Process Date Amt:
[BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT]+[CMPSOWNER_FUNDDESC].[FD_DESC_CD]
 
K

Klatuu

Put it the parenthesis as below to force the correct order of the calculations.
Process Date Amt:
([BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT])+[CMPSOWNER_FUNDDESC].[FD_DESC_CD]
 
T

TKM

great thank you

Klatuu said:
Put it the parenthesis as below to force the correct order of the calculations.
Process Date Amt:
([BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT])+[CMPSOWNER_FUNDDESC].[FD_DESC_CD]

TKM said:
I need to get the results from:
[BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT] and then add those
results to: [CMPSOWNER_FUNDDESC].[FD_DESC_CD]

Would this work? It seems I am getting different results then what I am
looking for.

Process Date Amt:
[BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT]+[CMPSOWNER_FUNDDESC].[FD_DESC_CD]
Click to expand...
Click to expand...
 
T

TKM

Still wont work. Dont know why? Any ideas?

Klatuu said:
Put it the parenthesis as below to force the correct order of the calculations.
Process Date Amt:
([BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT])+[CMPSOWNER_FUNDDESC].[FD_DESC_CD]

TKM said:
I need to get the results from:
[BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT] and then add those
results to: [CMPSOWNER_FUNDDESC].[FD_DESC_CD]

Would this work? It seems I am getting different results then what I am
looking for.

Process Date Amt:
[BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT]+[CMPSOWNER_FUNDDESC].[FD_DESC_CD]
Click to expand...
Click to expand...
 
N

Naeem

If you want to first add the two digits and then multiply the result
with the first digit then put the parenthesis around the sum and then
multiply them.
access will first do what is in the parenthesis, then priority is given
to ^ (exponent), then to * and /, finally + and -
so here is the suggestion:

[BUY_SELL_UNIT_CT]*([Cmpsowner_Unit_Value_1].[UVAL_AMT]+[CMPSOWNER_FUNDDESC].[FD_DESC_CD])
Still wont work. Dont know why? Any ideas?

Klatuu said:
Put it the parenthesis as below to force the correct order of the calculations.
Process Date Amt:
([BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT])+[CMPSOWNER_FUNDDESC].[FD_DESC_CD]

TKM said:
I need to get the results from:
[BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT] and then add those
results to: [CMPSOWNER_FUNDDESC].[FD_DESC_CD]

Would this work? It seems I am getting different results then what I am
looking for.

Process Date Amt:
[BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT]+[CMPSOWNER_FUNDDESC].[FD_DESC_CD]
Click to expand...
Click to expand...
Click to expand...
 
Top