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