Edward,

>>I have a table where I need to retrieve all of the fields of the unique records, however _exclude_ one of the fields from consideration of unique while _including_ that field in the ouput.

>Select * From table1 Group By field1,field2,field3 && but don't include field_x in Group by clause

Thank You! That was _exactly_ what I needed. I've stuggled with this type of problem before and have used poor workarounds to solve it, but this is sooo much better!

thanks again..

marc mandel