Adding then Multiplying in one expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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]
 
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]
 
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...
 
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...
 
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...
 
Back
Top