Help in report

[NomoreSpam4Me]

Hi, i have a report of missing days of work.
In the detail of the person i have [MyDate].

there can be several date, like Monday, january 1
Friday, january 5 .....

Problem: I want to count the number of monday missed, number of friday
missed etc.. for 1 person.
I thought i would go with something like =Count([MyDate]) but that
doesnt help me at all. It just return how many times the person was
sick.

Any idea how can i achieve it.

I'm on access 2000. And win XP. thx.

[Phil Stanton]

Try something like

SELECT Weekday([TheDate]) AS Expr1, Count(Weekday([TheDate])) AS Expr2
FROM Dividends
GROUP BY Weekday([TheDate]);

HTH

Phil
"No***********@hotmail.com" <ug********@hotmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

Hi, i have a report of missing days of work.
In the detail of the person i have [MyDate].

there can be several date, like Monday, january 1
Friday, january 5 .....

Problem: I want to count the number of monday missed, number of friday
missed etc.. for 1 person.
I thought i would go with something like =Count([MyDate]) but that
doesnt help me at all. It just return how many times the person was
sick.

Any idea how can i achieve it.

I'm on access 2000. And win XP. thx.