This is more of a general sql query question rather than a direct
question about Base, but here I go anyways.
I have two tables with the following relevant fields that record
inventory transactions.
tblSales
ItemNo
Date
Quantity
tblPurchases
ItemNo
Date
Quantity
Here would be some sample data:
tblSales
ItemNo Date Quantity
xyz 01/01/10 1
xyz 01/01/10 1
tblPurchases
ItemNo Date Quantity
xyz 1/12/09 1
xyz 2/12/09 2
xyz 3/12/09 1
Now, how do I go about creating an ageing report from these two tables?
Thanks for any hints or references that you may have.
Keith
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
