Problem with in memory ADODB rs

[praymond]

12 fields in the rs.
code reads;
.
with rsTmp
.Sort = "COST" ' FieldType double, want it in ascending order
.Filter = "COST > 0" ' Do not return records with 0 in COST
end with
.
problems I get are:
a) sort does not happen, still get physical order of rsTmp
b) returns all records, not just the ones where COST > 0.
.
This works on a rs created from a physical table, but not on an "in memory" rs.
Any ideas?
Thanks

[vbUserName]

See the MSDN, some kind of recordsets don't support sorting and filtering. If you do open the recordset with an sql instrution, you can order te rcords in the sql statement