sort recordset by 2 fields

[aonefun]

I am aware that if you would like to sort records by 2 fields, you list both fields separated by a comma after ORDER BY (i.e. ORDER BY Name, Date)

With the above code, the only way records will sort by Date is if they are identical other than by their date.

Now what if I would really like to do is first sort records that share a common Name value regardless of other field values and then sort by Date ( Something like "First ORDER BY Name which contains the value of "PC" and then ORDER BY Date DESC")

Can this be done?

[Newsgroup_User]

You can use a CASE statement in the ORDER BY clause.

"aonefun" <webforumsuser@macromedia.com> wrote in message
news:g7fvjq$qgs$1@forums.macromedia.com...
>I am aware that if you would like to sort records by 2 fields, you list
>both
> fields separated by a comma after ORDER BY (i.e. ORDER BY Name, Date)
>
> With the above code, the only way records will sort by Date is if they are
> identical other than by their date.
>
> Now what if I would really like to do is first sort records that share a
> common Name value regardless of other field values and then sort by Date (
> Something like "First ORDER BY Name which contains the value of "PC" and
> then
> ORDER BY Date DESC")
>
> Can this be done?
>