Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    8

    Unanswered: orderby in a table

    kinda sad but i can't figure out the "orderby" in a table
    i want to order by a field called LAST NAME so do i just type


    [LAST NAME] DESC

    in the orderby section of the properties for this table?

    or

    = [LAST NAME]

    or

    = "[LAST NAME]"

    or something else. I've tried all of the above with no success. Thanks in advance.

  2. #2
    Join Date
    Nov 2002
    Posts
    150

    Re: orderby in a table

    Try tablename.fieldname

    If that does not work, open your form, click in the field you want it sorted by, hit the appropriate sort button, and then save the form.

    If that does not work, do it in the form open event.

Posting Permissions

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