Re: How to summarize recordset...Select Distinct alternative?

ORDER BY 1,2,3 ...is a way to order by first field, second field, third
field? (regardless of field names)

No. It is ORDER BY the columns in ther SELECT
So if I had

ORDER BY 4

it would be

ORDER BY COUNT(FldItem)

in the first select. You can mix them as well:

ORDER BY 1,field2,4

Stephen


.