Hi Paul, ssanfu and orange,
Thanks so much.
To make it simple, I concatenated all the Keys that would be grouped and added the column to my data table. then I took Paul's example and made the following.
Code:
SELECT Max([USGS US States And Cities Final].[FEATURE_ID]) AS MaxOfFEATURE_ID, [USGS US States And Cities Final].Key_FN_FC_SN_CN, [USGS US States And Cities Final].Key_FN_SN_CN, [USGS US States And Cities Final].STATE_NUMERIC, [USGS US States And Cities Final].COUNTY_NUMERIC, [USGS US States And Cities Final].FEATURE_NAME, [USGS US States And Cities Final].FEATURE_CLASS, [USGS US States And Cities Final].STATE_ALPHA, [USGS US States And Cities Final].COUNTY_NAME
FROM [USGS US States And Cities Final]
GROUP BY [USGS US States And Cities Final].Key_FN_FC_SN_CN, [USGS US States And Cities Final].Key_FN_SN_CN, [USGS US States And Cities Final].STATE_NUMERIC, [USGS US States And Cities Final].COUNTY_NUMERIC, [USGS US States And Cities Final].FEATURE_NAME, [USGS US States And Cities Final].FEATURE_CLASS, [USGS US States And Cities Final].STATE_ALPHA, [USGS US States And Cities Final].COUNTY_NAME
ORDER BY [USGS US States And Cities Final].STATE_NUMERIC, [USGS US States And Cities Final].COUNTY_NUMERIC, [USGS US States And Cities Final].FEATURE_NAME;
It worked great. I am not deleting any rows, and I created a unique set of rows.
Now I have to crack the nut for using a case select statement to priortize the feature class by (Military, Populated Place, Island, etc)..It looks like ssanfu put the "having" statement may be in the direction. Will try that on my own before asking for help.
Thanks again for all of your help and certainly ssanfu for the effort put forth (I really like how you put the having statement in there),
Wayne