Sort Data Report

OK I've managed to create a DataReport thru
the vb program and it works great but how do
I get it to sort my records by LastName
ascending. I've tried to find info on SQL,
and have had some responses but where do I
put the code:
"SELECT*FROM members ORDER BY LastName"
or is there another way to sort these records
to show up on my report in the order I want.
I'm using Access97 db with vb6.
Thanks,
newvbr

If it needs a RecordSource or similar, use that code.

I am looking at the same right now.

Where did you put that line of SQL?

Thanks