Counting of Records

Results 1 to 3 of 3

Thread: Counting of Records

  1. #1
    Kantoi Guest

    Default Counting of Records

    I&#039m 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.

  2. #2
    muz Guest

    Default RE: Counting of Records

    use if not rs.eof or rs.recordcount!=0<BR>then movenext<BR>&#060;%=rs("field")%&#062;<BR>somethin g along those lines<BR>my email account is<BR>Contact me for further details!

  3. #3
    Kantoi Guest

    Default RE: Counting of Records

    I have managed to figure it out.<BR><BR>Thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts