Results 1 to 2 of 2
  1. #1
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286

    Make TEXTBOXES sort by DESCENDING order

    hello i have several textboxes in tabular format on a form. these are all bounded. I want to sort the output by descending order with the textbox called "date requested", making it show the most recent dates first then oldest.

    i have the main form order by property set to: Query1.[Date Requested] DESC



    but it doesnt work?? thanks!

  2. #2
    jscriptor09 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    60
    Hi
    I am not sure I understand why you are trying to sort in the form instead at the source.

    It seems that you have a query set up already, the order by should be based on the Table field!! as in :

    ORDER BY Table1.[Doc ID] DESC;

    !!!!
    Hope this helps

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 10-07-2011, 08:13 PM
  2. Multivalue field sort order
    By bdaun in forum Forms
    Replies: 0
    Last Post: 09-05-2011, 12:27 PM
  3. Paradox Sort order for linking tables to access
    By Jimmy in forum Import/Export Data
    Replies: 0
    Last Post: 02-02-2010, 03:13 AM
  4. Sort Order Variation with nulls
    By jonsuns7 in forum Queries
    Replies: 1
    Last Post: 10-09-2009, 03:10 AM
  5. Access 2003, sort order property of a form
    By Rick West in forum Forms
    Replies: 11
    Last Post: 09-17-2009, 08:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums