Rows 2 and 4 differ only in the ID column. Also, why does this table
have both Customer and CustomerID if that information is in tblCustomer?
Shouldn't there also be a tblArticle to hold information about articles?
select customer, insertedweek,
sum(custamount) as custamount, sum(custvalue)as custvalue
group by customer, insertedweek
--then to see the detail you will have to use sometype of paramater
"select customer, insertedweek, custamount, custvalue
where customer = '" & customer & "'"
not sure how you will are passing parameter, assuming in vb6, so you will have to dim customer as string and then set it equal to the customer that you selected so when you click on it you pass it to the details query.