Jeff,
Using the ORDER clause that can take more than one field. The second field will only be used for identical values in the first field.
HTH,
Marc
>Using a SQL statement, I extract ten data records on the basis of highest to lowest value. So I might have ten records with $10.00 at the top and $1.00 at the bottom. If there are more than one record with the same value, they need to be listed but in order by a second value, perhaps zip code. Is there a way to implement this inside the SQL statement?
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
