This should work correct? But it does not!

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

Guest

I am trying to do some calculations in my query (basic) but it does not work.
Example:
test:
([BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1.UVAL_AMT])+[cmpsowner_Transact_Detail].[PlanID]
Any help is appreciated. Yes all of them are number data types
 
TKM said:
I am trying to do some calculations in my query (basic) but it does not work.
Example:
test:
([BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1.UVAL_AMT])+[cmpsowner_Transact_Detail].[PlanID]
Any help is appreciated. Yes all of them are number data types
Click to expand...

Can you post the SQL of your query, and a few sample rows from the
result set?
 
You are missing brackets [] in the [Cmpsowner_Unit_Value_1.UVAL_AMT]. It
should read [Cmpsowner_Unit_Value_1].[UVAL_AMT]

([BUY_SELL_UNIT_CT]*[Cmpsowner_Unit_Value_1].[UVAL_AMT])+[cmpsowner_Transact_Detail].[PlanID]
 
Back
Top