Posted by Tim on 09/29/55 11:51

here's a good one for you...

I want to return the last 20 records I have modified. I have a
datemodified field - excellent.
So I run a query to select the top 20 when ordered by datemodified
desc.
But now I have these results I want them sorted by companyname.

Is this possible?

Yes I could use my GUI to do the second sort, but can it be done just
in a query?

Thanks

Tim

• Next in forum: Re: Combining 2 tables with date ranges
• Prev in forum: Re: Creating Cursor from Stored Procedure
• Thread view: sorting twice?!

[Reply to this message]