Solved

Add calculated field to query comes from 3 tables

Posted on 2012-04-06
2
277 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

743 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now