Good day Guys
Back at it again with my NOOBNESS in Access.
However, i have gotten past the tables and the forms, now I am at the queries.
What I would like to achieve is this:
I have 2 x Tables: 1) contains the delivery/return number, project, dates etc. - It also has a field called "Transaction_Type" to stipulate either delivery or return (tbl_transactionlist)
2) contains the actual details of the delivery/return details e.g. 10 of Item 1, 20 of Item 2 was delivered / returned (tbl_transactions)
The doc number field is the relationship field between these two tables as the doc number is on both tables.
I would like to make a summary query that shows per site the following:
What needs to be accounted for though, is that for example:
Item Code Site 1 Site 2 A1 20 10 A2 0 20 A3 10 10
Site 1 has four deliveries and 1 return of equipment code A1:
Delivery 1: 5
Delivery 2: 10
Delivery 3: 8
Delivery 4 : 3
Return 1: 6 - Note This will be minussed from the deliveries to equal a total of 20.
Can someone please explain to me how to do this.