D
David
I have a table in which data is entered through a SubForm
with fields for QuantityIn, QuantityOut and Adjustment
and a Transaction Date Field. An ItemID is stored in an
alternative table. I am attemting to put together a Query
which when it is accessed by a Form with other details
relating to the particular item displayed will Sum the
QuantityIn Entries, the QuantityOut entries, the
Adjustment entries for just that item and from that
calculate a Balance In Stock and display the result in
the Form.
I just have not been having any success with this task at
all. I should be able to get around the syntax if I could
just get an understanding of the best proceedure to
follow. Any help would be appreciated.
with fields for QuantityIn, QuantityOut and Adjustment
and a Transaction Date Field. An ItemID is stored in an
alternative table. I am attemting to put together a Query
which when it is accessed by a Form with other details
relating to the particular item displayed will Sum the
QuantityIn Entries, the QuantityOut entries, the
Adjustment entries for just that item and from that
calculate a Balance In Stock and display the result in
the Form.
I just have not been having any success with this task at
all. I should be able to get around the syntax if I could
just get an understanding of the best proceedure to
follow. Any help would be appreciated.