I have SELECT DISTINCT id, price, ... FROM ~~ WHERE ~~ = ~~...<BR><BR>Is it possible to also add in COUNT somewhere into that statement?
Only if you put the rest of yer fields in a GROUP BY clause since they're not aggregates.
Is it possible to count the number of records in another recordset? If so how?
Not sure what you mean by that. Could you give me an example?