I want to be able to order my records by the day of the week. Meaning I want to sort by date, but just by the day of the week, all Monday's together, all Tuesdays together,etc.

With DAO I could use the recordset property sort.
Like This:

temprecset.sort = "WeekDay(Date)"

Using the VB function WeekDay.

But with ADO I can't use the sort function.

Any ideas??????

Thanks in advance.

I figured it out myself. I didn't realize that you could just insert the VB Function right into the Select statement itself and it would work fine.

Thanks anyway


[Edited by Jimmer on 06-15-2000 at 02:53 PM]