Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    133

    Unanswered: newbie:sort in date field of a form

    Niewbie question:
    I'm new to VBA of microsoft access and i have following problem. I think it's simple but I still can not solve.

    I have a form with a date field from 01-01-2000 to 09-10-2004
    and my form is sorted from 01-01-2000 to 09-10-2004, for example:
    01-01-2000
    01-02-2000
    01-03-2000
    ...
    ...
    11-11-2002
    ...
    ...
    09-10-2004

    But I want to sort it descending, for example:
    11-11-2002
    ...
    ...
    09-10-2004
    ...
    ...
    11-11-2002
    ...
    ...
    01-03-2000
    01-02-2000
    01-01-2000

    thanks in advanced



  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    In the properties windwo, the secound tab [Data] click the [...] of the first property which is RecordSource then choose your table where your data are stored in a query, then in the sort field of the query choose Dessending

  3. #3
    Join Date
    May 2004
    Posts
    133
    many thanks. I forgot it.

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Did it function as you wish?

Posting Permissions

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