select ListName, count(*), sum(Info is not null)
from ListTable
group by ListName
= Original Message Follows =
From: John Berman [EMAIL PROTECTED]
Subject: Count of two fields
Wonder if you can help
I have a table with a number of fields but the
List Name
Member
Info
Ever member
Wonder if you can help
I have a table with a number of fields but the
List Name
Member
Info
Ever member in the table has a list and some members have something in the
info field, Im after a count by list name
So for instance the result im after would be something like