PC Review


Reply
Thread Tools Rate Thread

counting data from an Access database

 
 
=?Utf-8?B?dGltbXVsbGE=?=
Guest
Posts: n/a
 
      6th Mar 2007
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
 
Reply With Quote
 
 
 
 
Tim Williams
Guest
Posts: n/a
 
      6th Mar 2007
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 news0A2D7EA-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



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP: VBA Code to extract data from an SQL Server database and put it into Access Database Clinton M James Microsoft Excel Programming 1 8th Oct 2007 12:44 AM
HELP: Need macro for excel to get data from server database and use results to populate an Access Database Clinton M James Microsoft Access 1 7th Oct 2007 04:32 PM
Date counting with data from Access =?Utf-8?B?VmFsRW5n?= Microsoft Excel Misc 1 10th Sep 2007 09:13 PM
How do I export data from Access database to Lotus Notes database =?Utf-8?B?TGl0dGxlIE1pc3MgU3Vuc2hpbmU=?= Microsoft Access External Data 0 18th Jan 2006 05:51 AM
How do I transfer data from Works database to Access database? =?Utf-8?B?U2hhcm9u?= Microsoft Access Getting Started 2 22nd Mar 2005 04:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:08 PM.