Query TODAY & Time value

[swaink]

Hi All

May I seek advice please

I am trying to use a query to feed a Pivot table but I want to make it dynamic so that the user does not need to change anything.

The only point I am struggling is with locking it down to look at TODAY & NOW

I need to set the query to count occurences of an event where the date is TODAY, I also need to tie this down to a fixed time "06:00:00" for the start of the range but a dynamic time for the end range.

This is to ensure I have a running count for each of the events I am tracking

I have tried Between TODAY & '06:00:00' AND TODAY & NOW without success
for example this would have looked like between '2011-09-23 06:00:00' AND '2011-09-23 08:00:00

Any advice will be appreciated

Thank you

Kevin

 

[CharlesChuckieCharles]

This is an SQL query not an Excel query right?

Not all data sources would recognise a date as for example '2011-09-23 08:00:00' which appears to be SQL Server style

if its Ms Access you may need #23/09/2011 06:00# so you need to understand your datasource