Ok Im a first time poster on here so if someone could help me I really really need it. I have a table that has a field called [DateTime] and another field that has numbers of calls via that time frame. I have created a form that has fields on it that are for the days of the week (IE Mon, Tues )with formula's all of them but the first on to give me the days of the week. When they but the date in Mon. it autofills the other 6 fields with the dates. All of it works 
Now here is my problem, I am trying to create a query that will pull all records in the date range, but here is the trick they only want the records that are after and before a time range on those dates. Here is the query that I wrote ( which is not working ) Please any help or ideas.I have 2 fields the first field is "Calls" and the second is "DateTime"
In my DateTime field this is the Criteria that I used:
>=[forms]![Shifts]![Mon]:00:00 PM# And <[forms]![Shifts]![Tues]:00:00 AM#
