complicated query : Show weekday with time criteria and group 1

[hsingh1981]

Hi all i am trying to do query which shows counts the number of records where the date is > then 01/02/2008 onwards. But show data for only weekdays (monday to friday). With a time range off 08:00 am to 20:00.

eg.

NumberOfRecs DateInserted
6 Feburary
20 March
13 April


Don't know how to filter for weekdays and count them? this is what i got so far

SELECT tbl_METOBS.METOBSID, tbl_METOBS.TimeAdded, Format([DateAdded],"mmmm") AS DateInserted
FROM tbl_METOBS
WHERE (((tbl_METOBS.DateAdded)>=#2/1/2008#))
ORDER BY tbl_METOBS.DateAdded, tbl_METOBS.TimeAdded;

 

[Golom]

SELECT Format([DateAdded],"mmmm") AS DateInserted, 
       Count(*) As [Number of Records]

FROM tbl_METOBS

WHERE DateAdded >= #2/1/2008# 
  AND Weekday(DateAdded) BETWEEN 2 And 6
  AND Hour(TimeAdded)    BETWEEN 8 And 20 

GROUP BY Format([DateAdded],"mmmm") 

ORDER BY [DateAdded];

 

[hsingh1981]

EXCELLENT, just what i needed