Sort by Date (Latest Date that is)

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Sort by Date (Latest Date that is)

    :confused; Hello I have an access db which has text feilds and has a date
    feild set to the default value of Now() I want to be able to filter a
    recordset so the latest or most recent date is first to last? How would I
    accomplish this? ~Speegs

    Speegs Guest

  2. Similar Questions and Discussions

    1. SQL Sort by date
      This is probably very trivial, but I'm stuck. I have a audit log table like this: Order_Id Status Timestamp 12345 READY ...
    2. Sort by Date in Datagrid
      I can`t Sort by Date in Datagrid, it didn`t read the values as date, it is listed like text. Someonte knows a script to make it correctly? Thank`s.
    3. Get latest (by date) record and combine it with sum()
      Hello group, I have an SQL statement which pulls data from a table as follows: " SELECT tblSites.sites_siteno, " & _ "...
    4. SORT BY DATE
      Is it possible when downloading images and then modifying them to include the date they were taken and have that figure (along with Name, Type, Size,...
    5. Sort on Date Column
      1. I have sorts on Date and Name column heads Initial sort is on ORDER BY Date DESC Date Name...
  3. #2

    Default Re: Sort by Date (Latest Date that is)

    Speegs

    ORDER BY DatefieldName DESC

    Brendan

    "Speegs" <webforumsuser@macromedia.com> wrote in message
    news:d0s3tk$m4p$1@forums.macromedia.com...
    > :confused; Hello I have an access db which has text feilds and has a date
    > feild set to the default value of Now() I want to be able to filter a
    > recordset so the latest or most recent date is first to last? How would I
    > accomplish this? ~Speegs
    >

    Singularity.co.uk Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139