T
TKM
I have a query which looks like this..
Process Date Amount:
[CMPSOWNER_UNITS_BUY_SELL].[BUY_SELL_UNIT_CT]*[CMPSOWNER_Unit_Value].[UVal_Amt]
I am trying to get results from the above field and use them in another
query multipling by another field in a table.. I am trying to do this..
Transaction Total: [Process Date Amount]*[CMPSOWNER_FUNDDESC].[FD_DESC_CD]
How would I go about multiplying one query results into another query
results based of the aobve fields? Notice I am trying to use PROCESS DATE
AMOUNT from my other query and multipy by another table and filed. Access
wont let me do this why?
Process Date Amount:
[CMPSOWNER_UNITS_BUY_SELL].[BUY_SELL_UNIT_CT]*[CMPSOWNER_Unit_Value].[UVal_Amt]
I am trying to get results from the above field and use them in another
query multipling by another field in a table.. I am trying to do this..
Transaction Total: [Process Date Amount]*[CMPSOWNER_FUNDDESC].[FD_DESC_CD]
How would I go about multiplying one query results into another query
results based of the aobve fields? Notice I am trying to use PROCESS DATE
AMOUNT from my other query and multipy by another table and filed. Access
wont let me do this why?