Results 1 to 2 of 2

Thread: Field value count

  1. Aug 29th, 2000, 09:42 AM #1
    Guest

    Talking

    Is there a way to get the count of the values in a field (DAO) without using an SQL statement?
    If there isn't then what is the SQL statement to use to get the count?
    Reply With Quote Reply With Quote
  2. Aug 29th, 2000, 03:24 PM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    SQL:

    select field, count(field) group by field
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width