ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   counting data from an Access database (https://www.excelbanter.com/excel-programming/384653-counting-data-access-database.html)

timmulla

counting data from an Access database
 
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

Tim Williams

counting data from an Access database
 
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





All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com