VBA sql queries to filter out certain days in a week

[zx3]

I m trying to write a sql query in vba project, only get those records where date is a monday or a wednesday, currently i got something like



Me.RecordSource = "SELECT * FROM eResult WHERE WeekDay(rdate)='2' OR WeekDay(rdate)='4' ORDER BY eResult.rdate DESC"

please help to fix the above, thanks.

[lfpm062010]

For reading more about it here.
http://office.microsoft.com/en-us/ac...001228933.aspx

WeekDay returns a integer value. You don't need the "'".

Me.RecordSource = "SELECT * FROM eResult WHERE WeekDay(rdate)=2 OR WeekDay(rdate)=4 ORDER BY eResult.rdate DESC"

[zx3]

Thanks lfpm062010 , i kind of thinking it would be easy but for the last hour i search the web like crazy thanks again.