Something like:

select count(t.*) from tablename t
select count(t.*) from tablename t where t.fieldname = "whatever"

--
Tim Williams
Palo Alto, CA


"timmulla" wrote in message ...
I've successfully been able to retreive Access data and bring it into excel
with the help of postings from this website. I wanted to see if someone
could provide some code or insights that could help me count specific access
records, instead of retreiving them. Is this possible?

any help would be appreciated
--
Regards,

timmulla