D
David
Thanks Billy for responce. I'm getting a bit bogged down
on the query. I am displaying each item in a form (page
at a time) with a subform showing all the transactions. I
would like to show the up-to-date stock quantity ie. the
totals from the subform where the stock quantity =
Opening Qty + Additions - Subtractions for just that item
only.
Problem 1: Currently my query is summing all transactions
for all the items in each collumn. Cant get to sum all
transactions for individual item only.
Problem 2: Assumeing I get that sorted out - where and
how do I do the calculations on the these totals to get a
final balance in stock just for each item.
on the query. I am displaying each item in a form (page
at a time) with a subform showing all the transactions. I
would like to show the up-to-date stock quantity ie. the
totals from the subform where the stock quantity =
Opening Qty + Additions - Subtractions for just that item
only.
Problem 1: Currently my query is summing all transactions
for all the items in each collumn. Cant get to sum all
transactions for individual item only.
Problem 2: Assumeing I get that sorted out - where and
how do I do the calculations on the these totals to get a
final balance in stock just for each item.