Query:Orderby?

MJJ · Jun 5, 2004

I have a report using a query that sorts on the last name.
It looks like I can change that query to sort on another
field, like the id using the orderby property. I tried
with no success. Can you help? I should be able to do it
in the query or the report shouldn't I?

MJJ

Duane Hookom · Jun 5, 2004

I don't think the sort order in a query is ever reliably passed to the
report. Reports should be sorted using the sorting and grouping dialog.

MJJ · Jun 6, 2004

-----Original Message-----
I don't think the sort order in a query is ever reliably passed to the
report. Reports should be sorted using the sorting and grouping dialog.

--
Duane Hookom
MS Access MVP

I don't follow. Can you explain?
.

MJJ · Jun 6, 2004

-----Original Message-----
do
.
OK! I got it but is there anyway to change it in VBA code?

Duane Hookom · Jun 6, 2004

You can do almost anything with code. Search Allen Browne's site at
http://members.iinet.net.au/~allenbrowne/tips.html for code on sorting a
report.