By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,321 Members | 1,932 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,321 IT Pros & Developers. It's quick & easy.

Help with statisitics

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.