Beregn antal dage i måneden

Ved ikke om det kan gøres anerledes, men en tabel hvori du har alle datoer/ugedage for året, og så 3 forespørgsler :

qry nr 1

SELECT tblDate.Year, Month(tblDate!OriginalDate) AS [Month], tblDate.WeekDay, Count(tblDate.OriginalDate) AS [No Days]
FROM tblDate
GROUP BY tblDate.Year, Month(tblDate!OriginalDate), tblDate.WeekDay
HAVING (((tblDate.Year)=Year(Date()-1)) AND ((Month([tblDate]![OriginalDate]))=Month(Date()-1)));

qry nr 2

SELECT tblDate.Year, Month(tblDate!OriginalDate) AS [Month], tblDate.WeekDay, Count(tblDate.OriginalDate) AS [No Days]
FROM tblDate
WHERE (((tblDate.OriginalDate)<=Date()-1))
GROUP BY tblDate.Year, Month(tblDate!OriginalDate), tblDate.WeekDay
HAVING (((tblDate.Year)=Year(Date()-1)) AND ((Month([tblDate]![OriginalDate]))=Month(Date()-1)));

qry nr 3

SELECT qryCountDays_01.Year, qryCountDays_01.Month, qryCountDays_01.WeekDay, qryCountDays_02.[No Days], qryCountDays_01.[No Days], [qryCountDays_01.No Days]-Nz([qryCountDays_02.No Days]) AS Remain
FROM qryCountDays_01 LEFT JOIN qryCountDays_02 ON (qryCountDays_01.WeekDay = qryCountDays_02.WeekDay) AND (qryCountDays_01.Month = qryCountDays_02.Month) AND (qryCountDays_01.Year = qryCountDays_02.Year);

Kan du se systematikken ?

Hej Jensen !

Lidt bøvlet måske, men det virker. Tak

Der er sikkert andre metoder :-)

Jeg takker :-)