I am hoping someone can help with a wall I have run into. I have a database with a series of numbers in respective fields in the database

(e.g. field1=300, field2=200, field3=100, etc...) can anyone tell me how I set up a query so the I get the max min and avg of each record instead of each field?

Thanks in advance for your help

No way to do this in a query that I am aware of.

You might try posting in on the news server:
thedbcommunity.com news server

You would have to do that using a script.
-DL

Actually, you could do that with a compound "set" query -- but I never really figured out how to work those. You could also do it using a series of 3 or 4 queries in a row. It would be a little pain in the neck to set up, but once you did, you could save it and re-use it as needed.

-DL