if you put all 6 in a array, you can use a sorting algorithm to order them from low to high.

http://en.wikipedia.org/wiki/Sorting_algorithm

Average maximum=average of the 3 highest numbers, average minimum=average...

I work 38 hours a week with flexi-time. Life is more than work alone.

For sql server 2000 it is best to patch to service pack 3a or higher, this to fix many bugs.

By applying the service pack there is also a great chance...

@@Servername is not null?

Have you applied any sql server service packs?

wow 1.2 Million Seconds

Are all transactions properly committed before logging out? All locks are freed? All cursors are properly closed & deallocated?

Is this with each connection?

Adding the name & ip to the windows hosts file?

windows\system32\drivers\etc\hosts

do you have some sample records?

There could be a flaw in one of the indexes.

Have you tried dropping & rebuilding them?

A difference between SP3 & SP4 is that SP4 doesn't always convert the variable to the matching datatype of the table column and might choose to convert all rows to...

Hello,

If you have any questions about sql server, post them in the forums. The scope of your question is rather broad.

Error checking is quite limited in sql server 2000.Basically you...

Have you checked consistency of the database(s)?

Does it occur when a certain statement is started? (sql profiler is a help here)

indeed odd.

Found it works with binary collation for this selection.

select * from test order by [name]

COLLATE Latin1_General_BIN

Have you tried updating Access 2000 servicepack 1 to service pack 3 or later?

Mdac is up to date?

Thanks for the suggestions. I will try them out.