Selecting from specific Date and Time range

[LindaRuble]

Hello,

I am trying to select specific entries from a certain date and time range. To be exact, I would like to select all data that was entered with a time and date stamp from the day before (after 10:00AM to 12:00AM Midnight) AND what was entered the following day (from after midnight up to 10:00AM).

Here is my query:


SELECT DISTINCT (Mid([ClientDiv].[Client_Division],1,3)) AS ABC2, RTIClientTracker.MR_Assoc, RTIClientTracker.Cut, RTIClientTracker.CutTime, Date() AS TheDate, DayAfter() AS DayAfter
FROM ClientDiv INNER JOIN RTIClientTracker ON ClientDiv.ID = RTIClientTracker.Client_Division
WHERE (((RTIClientTracker.MR_Assoc)="Linda") AND ((RTIClientTracker.Cut)=Date()) AND ((RTIClientTracker.CutTime)>#12/30/1899 10:0:0# And (RTIClientTracker.CutTime)<#12/30/1899 23:59:0#) AND ((RTIClientTracker.Division_Region)='West' Or (RTIClientTracker.Division_Region)='EPS' Or (RTIClientTracker.Division_Region)='North' Or (RTIClientTracker.Division_Region)='South' Or (RTIClientTracker.Division_Region)='Baylor')) OR (((RTIClientTracker.MR_Assoc)="Linda") AND ((RTIClientTracker.Cut)=DayAfter()) AND ((RTIClientTracker.CutTime)>#12/30/1899 0:1:0# And (RTIClientTracker.CutTime)<#12/30/1899 10:0:0#) AND ((RTIClientTracker.Division_Region)='West' Or (RTIClientTracker.Division_Region)='EPS' Or (RTIClientTracker.Division_Region)='North' Or (RTIClientTracker.Division_Region)='South' Or (RTIClientTracker.Division_Region)='Baylor'))


ORDER BY (Mid([ClientDiv].[Client_Division],1,3));

I am also sending you an image that might be easier to read:

Thank you in advance.

Linda

[rzw0wr]

You may want to try using "BETWEEN" for you times.

Dale