Solved

Add calculated field to query comes from 3 tables

Posted on 2012-04-06
2
309 Views
Last Modified: 2012-04-06
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
0
Comment
Question by:Mohammad Alsolaiman
2 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 37817198
Add this expression as a new field in your query:

NetQuantity: Strart_RetailUnit_Qty - [Quantity_Retail] * (TransType=1)  + [Quantity_Retail] * (TransType=2)
0
 

Author Closing Comment

by:Mohammad Alsolaiman
ID: 37817286
ma sha'a allah tabark allah
wonderful
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question