Access and Alphabetical ordering

Results 1 to 2 of 2

Thread: Access and Alphabetical ordering

  1. #1
    Join Date
    Dec 1969

    Default Access and Alphabetical ordering

    Is there a way to have ASP tell access to organice a FieldName by alphabetical order. I have a list of employees, listed as they join the company. I want to list them in a select box alphabetically, not by EmployeeID order(the autonumber generator which is always LastNumber + 1). Can this be done is ASP, or do I have to do an SQL call? Thanks in advance.

  2. #2
    Join Date
    Dec 1969

    Default RE: Access and Alphabetical ordering

    it would be much easier to do it in you SQL statement, since I&#039m guessing you&#039re doing an SQL statement to return the data in the first place...<BR><BR>something like this:<BR>strSQL="SELECT id,firstname,lastname FROM employees " & _<BR>"ORDER BY lastname"

Posting Permissions

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