sort recordset by 2 fields

Question

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 · Answer

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?
>

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.