Results 1 to 2 of 2

Thread: Order

  1. #1

    Thread Starter
    Fanatic Member Gimlin's Avatar
    Join Date
    Dec 2001
    Location
    Hell
    Posts
    734

    Order

    Ok say I have this in a database

    Mike 1
    Beth 2
    Sam 3
    Jack 4
    John 5
    Marry 6

    When printed I want it to be

    Beth 2
    Jack 4
    John 5
    Marry 6
    Mike 1
    Sam 3

    Alphabetical

  2. #2
    PowerPoster
    Join Date
    Jul 1999
    Posts
    5,923
    append
    Code:
    ORDER BY FieldName
    to the end of the SQL statement

Posting Permissions

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



Click Here to Expand Forum to Full Width