In one table, I have over a hundred records, many of them repeating the same name, but have other different fields. I need to list each name once and order them according to a rating. This is my SQL statement:<BR>=====<BR>SELECT DISTINCT name, location, pool, url, premlocation, sofa, beach, tennis FROM QryResort ORDER BY rating<BR>=====<BR>The error message I get is that the DISTINCT clause conflicts with the ORDER BY statement. What can I do?<BR>