Help in report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NomoreSpam4Me@hotmail.com - 02 Feb 2006 14:33 GMT

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.

Reply to this Message

Phil Stanton - 04 Feb 2006 19:22 GMT

Try something like

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

HTH

Phil

> Hi, i have a report of missing days of work.
>
[quoted text clipped - 13 lines]
>
> I'm on access 2000. And win XP. thx.

Reply to this Message