Question Summarize the data with Access (for the beginner)

[primala]

Hi,

I'm just a beginner in MS Access, and this is the first time I'm trying to use Access since I have a problem in spending time to calculate in Excel. I use MS Access 2010.

This is what I have now in the table :
- field 1 --> AFE Number (many)
- field 5 --> Item Number (many)
- field 14 --> Qty
- field 15 --> Source (many)

What I want is :
1. summarizing the quantity of material installed, based on :
- for each unique AFE Number (field 1)
- Item Number (field 5)
- Qty (field 14)
- Source (field 15) consist of : JDE Issuance, OP, S1, TRI, TRO, Installed
note : TRI = Transfer In ; TRO = Transfer Out

2. quantity of Material Issuance, should be :
- JDE Issuance + OP + S1 + TRI - TRO from field 15

3. quantity of Installed, should be :
- Installed, from field 15

The result should be like this, for example :
AFE Number Item # Matl Issuance Installed Balance
111000239 23135 100 75 25

Thanks in advance

 

[DJkarl]

You would use a query to get what you need. Any beginner reference on SQL would be helpful, here's one directed at using MS Access. http://office.microsoft.com/en-us/a...part-iii-writing-the-queries-HA010247313.aspx