Labels printing in alphabetical order!

  • Thread starter Thread starter Roger
  • Start date Start date
R

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.
 
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)
 
Back
Top