I have a table in MS Access which contains following fields :
Date of Production Short date like 10-Apr-09
Job Begin Time 24 Hours time like 07:00
Job End Time 24 Hours time like 19:25
Now, I want to filter only those records where Job begin time starts 7:00 AM of a particular date (say through Form) and ends 7:00 AM of next date. Say 7:00 AM of 10th Apri'l09 and 07:00 AM of 11th April'09.
I shall be thankful if anybody enlighten me how to make query for the above.