This should work correct? But it does not!

T

TKM

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
 
N

Neil Sunderland

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?
 
J

John Spencer

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