Help in report

[NomoreSpam4Me@hotmail.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.

[Phil Stanton]

Re: Help in report

Try something like

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

HTH

Phil
"NomoreSpam4Me@ hotmail.com" <ugo_lavoie@hot mail.com> wrote in message
news:1138890787 .943333.178340@ g43g2000cwa.goo glegroups.com.. .[color=blue]
> 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.
>[/color]