Why can not I group a report in access based on WeekDay? -

Why can not I group a report in access based on WeekDay? -

i have table created sql it. sql follow:

select maintable.person1id, weekdayname(weekday([calanderdate]),false,2) weekday, maintable.sesssiontype, maintable.calanderdate maintable;

i can generate normal study query, if grouping study based on weekday, generate error:

data mismatched in criteria expression.

if seek grouping based on calanderdate works long not putting weekday on grouping header.

what problem , how can prepare it?

i using access 2003.

try using weekday([calendardate]) grouping clause.

ms-access access-vba ms-access-2003