Filter between times

[bigderon88]

I have a date/time field in standard access format. I want a query that pulls from current date between 8AM and Noon and then one that does between noon and 4PM. Any help?

Thanks.

[pbaldy]

Try a criteria of

Between Date() & " 8:00" And Date() & " 12:00"