Help with statisitics

[Norman Fritag]

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

[R.A.Balder]

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

[Mike Storr]

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

[Chris2]

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