Count records between Time Period

[turnbuk]

Morning,



In Access 2007 I have a QUERY that needs to show the count of records between a certain time period however I can't seem to get it to work correctly possibly because it needs to group the FacilityName as well.

This is my query right now and what it pulls:

FacilityName | Date/Time

I want to be able to group the Date/Time along with the FaciltyName by counting how many records fall between a certain time period. I tried >=#10:00:00 AM# OR <=#11:00:00AM# as the criteria for Date/Time but it seemed to ignore it. Any recommendations?

Thanks

[pbaldy]

You want AND, not OR. Every possible time is either after 10 OR before 11. You could also use Between.