Labels printing in alphabetical order!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger - 11 Jan 2008 22:01 GMT

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.

Signature

Roger

Reply to this Message

Douglas J. Steele - 11 Jan 2008 22:08 GMT

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)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

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

Reply to this Message