S
SusanV
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
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