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

How to subtract a number from a Mergefield? 0
Access Access Report Works on One Machine but not Another 3
Help Please 5
Why is formatting not working in this statement? 4
Should I use a query for this? If so, how? 2
Overflow error on calculate field in query - Help Please 1
Form Filter should work, but it does not 1
Access Query problem 1

Back
Top