Sorting a recordset

From: kiloez (anonymous_at_discussions.microsoft.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 06:06:08 -0800

I'm trying to sort a recordset that is getting passed to an ADO data control and getting an error: "Expected end of staement". The code being used is as follows:

Set ctlADO.Recordset = rs
ctlADO.Recordset.Sort = "Amount" DESC

"Amount" is the field name I'm trying to sort on. Any help in sorting this out would be appreciated.

Relevant Pages

  • Re: Global Warming: Junk science at its [best] worst
    ... have to be more productive, and thus richer, to generate that amount ... generating energy sources would "help" (just assuming for the moment ... What sort of base would you expect of a retired electronic engineer? ... have the money or the resources to do the sort of economic analysis ...
    (sci.electronics.design)
  • Re: Need help with custom sorting
    ... I don't believe you can get Excel to recognize your sort pattern without the ... Is there any way that I can custom sort a list in this way: ... Item Amount ...
    (microsoft.public.excel.misc)
  • Re: how to vary sorts block?
    ... I want to be able to sort that array by ... def initialize ... Thing = Struct.new(:name,:amount) ...
    (comp.lang.ruby)
  • Re: Sorting large amounts of floats
    ... > I'm trying to figure out the best way to sort a large amount ... but this means that there can only be one access to that RAM ... bits till the next word clock in this selected state. ...
    (comp.arch.fpga)
  • Re: breaking the speed of light article on howstuffworks.com
    ... It's hard to explain because it is really just a vague idea in my ... >The amount man knows in comparison to the amount there is out there to ... >Every fundamental quality of the universe we describe might be ... at the beginning is sort of honorary. ...
    (sci.electronics.design)