Query:Orderby?

[MJJ]

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]

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]

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

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

 

[Duane Hookom]

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.