Ok this is a stupid question and I am killing myself for it but here it goes...

How do i use a SQL statement to populate a recordset instead of just opening the recordset. I need to sort some data before i load it in.

Thanks