Descending isn't

Results 1 to 3 of 3

Thread: Descending isn't

  1. #1
    Join Date
    Dec 1969

    Default Descending isn't

    For some reason my DESC specification in my request is having NO effect. Can anyone assist?<BR>Set ArticleCategoryRset1 = Connect.Execute("SELECT * FROM MainContent WHERE NonBrowsable = 0 AND CatLevel2 = &#039;" & CatList & "&#039; ORDER BY Identifier DESC") <BR>Incidentally it is an Access 2000 database<BR>Also, am I correct in assuming that Ascending is the default ordering method?

  2. #2
    Join Date
    Dec 1969

    Default Your assumption is CORRECT!! and it's

    strange why DESC wouldn&#039;t work.

  3. #3
    Join Date
    Dec 1969

    Default RE: Descending isn't

    Identifier may be a reserved word. Put sqaure brackets around it and see if that would make a difference.

Posting Permissions

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