Hi to all.

I need some help with my project.
I have a database that contain 4 tables: Items, Purchased, Sold, Stocks
I want to make a recordset from these database.
The Items database contains Item Information: BarCode, Name, Size, Price, Category
The Purchased database records Purchase ordered Items: BarCode, Units, Date
The Sold database records Sold out Items: Barcode, Units, Date
The Stocks database records available Items in stock: Barcode, Units, Date

I wanted to query the Database to get a result like this:
Code:
Items.Barcode - Items.Name - Items.Size - Sold.Units
But Sold database contains records with the same Barcode but different Date and Units. So I am looking for a way to automatically add Unit from records with same Barcode in a span of days.
I will need the result to display in a datareport.
I also want it in order by category.

I hope someone can help.