Hi,
I have a database showing quantities delivered by suppliers.
The main table, tblMain has the fields Supplier, Date, Quantity
The Supplier field is an ID from a table of suppliers.
What I need to do is produce an ADO query which retrieves a unique list of Supplier ID's between two dates with a sum of the quantity.
I then need to join that to the table of suppliers to obtain the supplier name from the supplier ID.
This is the code I have so far to just get the supplier and the sum. But the join isn't working and I haven't attempted to tackle the date range yet.
Please Login or Register to view this content.
Bookmarks