counting data from an Access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Something like:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database Connection 1
adjusting a macro that retreives access data 1
retreive Access via ADO 2
cell format printing 1
record count from system 3
Multiple sheet querries 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
import data with microsoft query 1

Back
Top