Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Add calculated field to query comes from 3 tables

Posted on 2012-04-06
2
Medium Priority
?
340 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

721 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