Records Count

Results 1 to 2 of 2

Thread: Records Count

  1. #1
    Join Date
    Dec 1969

    Default Records Count

    I want to count a certain record I have but only if there&#039;s a value in it. How can I do it?<BR><BR>Here&#039;s what I got so far:<BR>SQL = "select count(colors) FROM members_TABLE"<BR>rs.Open SQL,DSN,3,1<BR><BR>colors = rs("colors")<BR><BR>rs.close<BR><BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: Records Count

    SQL = "select count(colors) FROM members_TABLE"<BR>rs.Open SQL,DSN,3,1<BR><BR>colors = rs(0)<BR><BR>rs.close

Posting Permissions

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