Selecting a str Date

[benjimillard]

IIF( InStr(0,[Day],WeekdayName(Day(Date$()),0,"vbUseSystem"),1) >0 ,true, false)


or something similar (but this gives me a data mismatch error) not great at VB coding but have a bit of C++

i have a table that has a field that contains days such as monday teusday etc. the field can have more then one day eg "monday, thursday, Friday"
i would like a query that would return the record when the curent day is included in that field
Thanks

[June7]

Second thread today about multi-value fields.

Is this field set up as a combobox or listbox that allows simultaneous selection of multiple values or is it just a regular text string?

If just text string:
SELECT * FROM table WHERE DayField Like "*" & Format(Weekday(Date()),"dddd") & "*"));

If is a multi-value field:
SELECT * FROM table WHERE DayField.Value=Format(Weekday(Date()),"dddd");