Something like:
select count(t.*) from tablename t
select count(t.*) from tablename t where t.fieldname = "whatever"
--
Tim Williams
Palo Alto, CA
"timmulla" <(E-Mail Removed)> wrote in message news

0A2D7EA-EE03-47D7-A8FC-(E-Mail Removed)...
> 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