470,815 Members | 3,236 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,815 developers. It's quick & easy.

Help with statisitics

Hi there

I would want to run some statistic's of on table only.
1st the table is a compilation of information coming from various other
table. Sofar that is Ok.

Now I would like to sum, count, average the data sitting in that table and
don't what to use queries to extract the information.
What are my other options?
Class, Types??

kind regards
Norman
Nov 12 '05 #1
3 1121
Why don't you wan't to use queries? They are easy to create and effecient
for what you want to do. (And I don't know any other method to sum up
tables).

Brgds
Rolfern

"Norman Fritag" <mt*****@ozemail.com.au> wrote in message
news:FR****************@nnrp1.ozemail.com.au...
Hi there

I would want to run some statistic's of on table only.
1st the table is a compilation of information coming from various other
table. Sofar that is Ok.

Now I would like to sum, count, average the data sitting in that table and
don't what to use queries to extract the information.
What are my other options?
Class, Types??

kind regards
Norman

Nov 12 '05 #2
A query is likely the fastest and/or most efficient method of doing so.
Otherwise you'll need to create one or functions.
Even doing this, you'll likely need the most basic of queries to get your
info.

Mike Storr
www.veraccess.com
"Norman Fritag" <mt*****@ozemail.com.au> wrote in message
news:FR****************@nnrp1.ozemail.com.au...
Hi there

I would want to run some statistic's of on table only.
1st the table is a compilation of information coming from various other
table. Sofar that is Ok.

Now I would like to sum, count, average the data sitting in that table and
don't what to use queries to extract the information.
What are my other options?
Class, Types??

kind regards
Norman

Nov 12 '05 #3
Norman,

You will have to use VBA code.

1) You can instantiate a recordset of the table and iterate through it and
accumulate the data.

Check up on the OpenDatabase, OpenConnection, and OpenRecordset methods,
and the Database, Connection, and Recordset objects. Your choice of whether
to use DAO (Direct Access Objects), ADO (ActiveX Data Objects), or RDO
(Remote Data Objects; if it's available to you). The code is different
(though vaguely similar) for each type. DAO integrates well with Access,
ADO is very portable, and RDO is fast and lightweight.

Honestly, though, all of that is vastly more complicated and slower than
simply executing a Query.

Sincerely,

Chris O.
"Norman Fritag" <mt*****@ozemail.com.au> wrote in message
news:FR****************@nnrp1.ozemail.com.au...
Hi there

I would want to run some statistic's of on table only.
1st the table is a compilation of information coming from various other
table. Sofar that is Ok.

Now I would like to sum, count, average the data sitting in that table and
don't what to use queries to extract the information.
What are my other options?
Class, Types??

kind regards
Norman

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Jacek Generowicz | last post: by
6 posts views Thread by wukexin | last post: by
3 posts views Thread by Colin J. Williams | last post: by
7 posts views Thread by Corepaul | last post: by
5 posts views Thread by Steve | last post: by
8 posts views Thread by Mark | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.