Re: Query Order By then By...
- From: "John Spencer" <spencer@xxxxxxxxx>
- Date: Tue, 2 May 2006 15:43:00 -0400
In the query grid, there is a sort by line. The sort will by will be in the
order of the fields, however, if you want to display the fields in one order
and sort them in another order, just add the fields to the end of the grid a
second time, uncheck the DISPLAY and then set the sort to ascending or
descending.
"SusanV" <svanallen@xxxxxxxxxxxxxxx> wrote in message
news:%2374ujdhbGHA.3800@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,
I often use the query design view to put together quick and dirty queries
on my database that I will never use again, that I don't need a report
for, just need to get this particular data this one time for someone.
Is there a way to order by 2 fields - say by Date then by OrderNo in SQL
or in the design view? I know you can do multi-tiered sorting in a report,
but I don't need a report. What I've been doing is dumping it to Excel
then using Excel's sorting, but that adds another step I'd like to
eliminate.
TIA,
Susan
.
- References:
- Query Order By then By...
- From: SusanV
- Query Order By then By...
- Prev by Date: Re: Null Value error in Append qry
- Next by Date: Re: Date query
- Previous by thread: Re: Query Order By then By...
- Next by thread: Re: Query Order By then By...
- Index(es):
Relevant Pages
|
