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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access My Expression Contains Wrong number of arguments 0
Make one final list from four sources 1
Adding 2
Query totaling one field for unique values 2
Data Type Mismatch in Criteria Expression 2
pulling records from one table based of another table column 11
Expression Error in a Parameter Query 9
query to pull records based of subquery column 10

Back
Top