Labels printing in alphabetical order!

[Roger]

I created a Label using a Table in MS Office 2007 Access. The Field required
to be sorted is by Last Name. I can print all the Records (not alpha),
however I want them in alpha order.
I must be doing something wrong. Thank you.

 

[Douglas J. Steele]

The only way to control the sort order in reports is to use the Sorting and
Grouping dialog in the report builder. Even if the report is based on a
query that's sorted, the report (usually) doesn't respect the sort order of
the incoming recordset. (If you don't have a query, all bets are off,
because you can never make any assumption about the order in which records
are stored in tables)