Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Sorting by alphabet after new input

Discussion in 'Information Technology' started by Cranky, Jul 28, 2006.

  1. Cranky

    Cranky
    Expand Collapse
    Guest

    Hi

    I'm sure this is probably very easy, but I can't seem to do it.

    I've inherited a database of around 250 records. Since then I've added
    around another 50 names, which have had autonumber allocate their
    reference. However, when I print off all records in a report, the order
    seems all over the place, not the alphabetical order it is set to. I've
    gone into the table and sorted by surname, by autonumber, by various
    other fields, but the print order doesnt seem to match any of these.

    Is there a way of reallocating the autonumber so that every time I add
    a new record, the first name alphabetically is (re)allocated number 1,
    the next, 2, and so on?

    Thanks in advance

    Alan
     
  2. Loading...

    Similar Threads Forum Date
    Learn Punjabi The Creation of Gurmukhi Alphabets Language, Arts & Culture Dec 30, 2012
    Learn Punjabi Learn Gurmukhi - The Punjabi Alphabets Language, Arts & Culture Sep 16, 2009
    Learn Punjabi Gurmukhi Alphabet, Handwriting, from Billie Grosse the Font-maker Language, Arts & Culture Jul 15, 2009
    Learn Punjabi Gurmukhi Alphabet, Practice Tips, from Billie Grosse the Font-maker Language, Arts & Culture Jul 15, 2009
    Learn Punjabi Gurmukhi Alphabet, Additional Sounds, from Billie Grosse the Font-maker Language, Arts & Culture Jul 15, 2009

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    The sorting in the report is defined in the Sorting And Grouping dialog.

    Open the report in design view.
    In this dialog (on the View menu if you don't see it), choose the Surname
    field on the first row. You can also choose the FirstName field on the 2nd
    row if you want to sort by FirstName where people have the same Surname.

    For other contexts, you can create a query and use the Sorting row to
    determine the order of the records.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Cranky" <crankylemming@aol.com> wrote in message
    news:1148456067.649192.297370@g10g2000cwb.googlegroups.com...
    >
    > I'm sure this is probably very easy, but I can't seem to do it.
    >
    > I've inherited a database of around 250 records. Since then I've added
    > around another 50 names, which have had autonumber allocate their
    > reference. However, when I print off all records in a report, the order
    > seems all over the place, not the alphabetical order it is set to. I've
    > gone into the table and sorted by surname, by autonumber, by various
    > other fields, but the print order doesnt seem to match any of these.
    >
    > Is there a way of reallocating the autonumber so that every time I add
    > a new record, the first name alphabetically is (re)allocated number 1,
    > the next, 2, and so on?
    >
    > Thanks in advance
    >
    > Alan
     
  4. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    If it's only the printed report that you want sorted and not the actual
    query,form,table then you should sort the report itself.

    Open the report in design view and click the sort button (it's on the top
    menu) and sort the records as you want them to appear in your printed results.
    --
    Wayne




    "Cranky" wrote:

    > Hi
    >
    > I'm sure this is probably very easy, but I can't seem to do it.
    >
    > I've inherited a database of around 250 records. Since then I've added
    > around another 50 names, which have had autonumber allocate their
    > reference. However, when I print off all records in a report, the order
    > seems all over the place, not the alphabetical order it is set to. I've
    > gone into the table and sorted by surname, by autonumber, by various
    > other fields, but the print order doesnt seem to match any of these.
    >
    > Is there a way of reallocating the autonumber so that every time I add
    > a new record, the first name alphabetically is (re)allocated number 1,
    > the next, 2, and so on?
    >
    > Thanks in advance
    >
    > Alan
    >
    >
     
  5. Cranky

    Cranky
    Expand Collapse
    Guest

    Hi Wayne,

    Thanks for replying. I'd triedAllen's advice and it did what I needed.

    S:)
     
  6. Cranky

    Cranky
    Expand Collapse
    Guest

    Allen

    That worked prefectly.

    Thanks a lot.

    S:)
     
  7. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    No worries

    Enjoy
     

Share This Page