Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Dec 2001
    Location
    Santa Barbara, California, USA
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting Labels (Access 2003)

    I'm having trouble sorting labels in Access 2003. I'm using the label wizard to generate two columns of labels from data in two linked tables.
    Field 1 in Table 1 is the linking field to many records in Table 2..
    I would like them to be sorted by Field 2 in table 1, then Field 3 in Table 2, ignoring Field 1 completely. The field 2 sort works properly, but it then uses Field 1 as the secondary sort field, then field 3 as terthiery sort field.
    Any way to kill the field 1 sorting, which I would like the sort to ignore. Is this possible?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorting Labels (Access 2003)

    You can modify the sort order for the report (after the wizard has created it) in the View | Sorting and Grouping dialog. Make sure that Field2 is at the top, followed by Field3. If necessary you can delete a row in the dialog, and reorder the rows by dragging them up or down.

  3. #3
    Lounger
    Join Date
    Dec 2001
    Location
    Santa Barbara, California, USA
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting Labels (Access 2003)

    Yes, I've done that, but it still insists on using the linking field 1 as the secondary sort, even though it isn't anywhere in the sorting and grouping list. I've looked at and tried changing every option I can find to kill the field 1 sorting to no avail. I hoping someone knows of some flag that is well hidden that may control it.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorting Labels (Access 2003)

    Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  5. #5
    Lounger
    Join Date
    Dec 2001
    Location
    Santa Barbara, California, USA
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting Labels (Access 2003)

    Thanks,
    I've solved the problem. The other comments made me realize I was doing it correctly, so for the 14th time I deleted everything in the sorting and grouping box and re-added them, which didn't fix it, until I added to the labels the linking field that it was incorrectly sorting on, even though they weren't in the label before then. Actually having the linking field in the label appears to let Access properly know that it's to be ignored in sorting. I just made it transparent so it doesn't show.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •