I'm quite new in using ASP and MS SQL.<BR>I have 3 tables, Customers, Products, TxnLog. In the TxnLog I log amongst other things, the customerID,ProductID. Daily some of the customers will acquire several products and most of the times several times per day. I need to count the number of each product that each customer acquire on certain date. How should I do it? I got no problem in getting the number of customers that doing transaction and the total number of transactions for that day.<BR><BR>Please help me.<BR><BR>Thank you.