Search results

I got another question to ask: How to insert a form into this query? SELECT qryFlatCalendar.dteDate FROM qryFlatCalendar WHERE (((qryFlatCalendar.dteDate)<=#1/31/2008# And (qryFlatCalendar.dteDate)>=#1/1/2008#)); I've tried this one... but not possible... SELECT...

Ok,i've found out a probable solution from another forum but i still need some help to calculate total days for each month.The file is included in the attachment... Jan - 31 Feb - 28 or 29 Mar - 31 Apr - 30 May - 31 June - 30 July - 31 Aug - 31 Sept - 30 Oct - 31 Nov - 30 Dec - 31 Do i need to...

ya...i hope Liverpool can win the title this season ;p

So the example given in the link is the only solution? I mean we need to create an external table with all the dates required. My concern is , the table will be a long one as the incoming data would scretch up to years...imagine until 2020 :eek: .... also don't forget i still need to figure...

Thanks for the reply david. I need to sort the result by month and day. e.g: points | december | 01 | 02 | 03 ....until the end of the day 00xxx1 10 11 15 00xxx2 5 6 10 00xxx3 11 10 12 p/s:i know a good...

Here is my query. TRANSFORM Count(t_date.ftime) AS Sumftime SELECT t_date.gh FROM t_date GROUP BY t_date.gh PIVOT t_date.fdate; What i'm doing is count the number of clocking per points number. My problem is if there is no clocking for one date, it will not show this date in the query. So...