"How to..." Alphabetical Listing of Records

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default "How to..." Alphabetical Listing of Records

    "How to" question...

    I have an access db with only one table (5 fields): id, TestNumber, Book,
    Author, ReadingLevel, PointValue. I would like to have alphabetical listing
    of the records displayed by hyperlinks on the top of the page like:

    <Previous All | A | B | C | ....| Y | Z | Next>

    also would like to have only 25 records per page and bottom page numbering.

    I know this is a newbie question but I haven't being able to figure it
    out...

    Thanks in Advance,

    CR


    CR Guest

  2. Similar Questions and Discussions

    1. Creating a system to "move" records up or down in atable
      Hey All, I have a simple database table of info that I would like to be able to change the output order of when queried, using a sort column....
    2. ASP.NET in DW 2004 "Problems Inserting Records into anAccess DB"
      Hi: I am having problems inserting records into an Access 2003 DB. I am coding with ASP.NET "VB". I have no problems reading records, but for...
    3. Go to "page" # field, all records after that pg appear?
      In editing my db, I have realized I am missing an important feature. The db is for entering info; there is a name for the info., a category, page #...
    4. If recordset .BOF and rstime.EOF Then giving me "No records"
      I'm using and If with the BOF and EOF methods to start looping thru a group of records: If rstime.BOF and rstime.EOF Then response.write "There...
    5. "Start" "Program" "Menu" list is empty
      For what ever reason my list of installed programs in my "Start" "Programs" menu is empty. Anyone know how to restore the list. Thanks for your...
  3. #2

    Default Re: "How to..." Alphabetical Listing of Records

    Some ideas
    [url]http://www.aspfaq.com/2352[/url]

    --
    Aaron Bertrand
    SQL Server MVP
    [url]http://www.aspfaq.com/[/url]




    "CR" <crangel@rdtek.com> wrote in message
    news:OJXf3c17DHA.2712@tk2msftngp13.phx.gbl...
    > "How to" question...
    >
    > I have an access db with only one table (5 fields): id, TestNumber, Book,
    > Author, ReadingLevel, PointValue. I would like to have alphabetical
    listing
    > of the records displayed by hyperlinks on the top of the page like:
    >
    > <Previous All | A | B | C | ....| Y | Z | Next>
    >
    > also would like to have only 25 records per page and bottom page
    numbering.
    >
    > I know this is a newbie question but I haven't being able to figure it
    > out...
    >
    > Thanks in Advance,
    >
    > CR
    >
    >

    Aaron Bertrand - MVP Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139