Add calculated field to query comes from 3 tables

Hi:
I have Query ” qtyTransactionDetails" comes  from 3 tables(tblItems, tblTransactionsItems and tblTransactions).
Can I add a calculated field shows "net quantity", which is = tblItems. Strart_RetailUnit_Qty + (tblTransactionsItems. Quantity_Retail   where tblTransactions.TransType=1 ) - (tblTransactionsItems. Quantity_Retail   where tblTransactions.TransType=2 )
Please see the attached database
-Inventory-be---EE.accdb
Mohammad Alsolaimanapplication programmerAsked:
Who is Participating?
 
mbizupCommented:
Add this expression as a new field in your query:

NetQuantity: Strart_RetailUnit_Qty - [Quantity_Retail] * (TransType=1)  + [Quantity_Retail] * (TransType=2)
0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
ma sha'a allah tabark allah
wonderful
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.