As Arnelgp says your data is incorrect the times in Summer day and Night are incorrect. They overlap.
Thanks Minty & Arnelgp.
I am bit slow in picking up this access, so please excuse me for that...
My Data or query has nothing to do with actual timeslot of the day i.e. to find out is it summer, day time or Winter ,evening time.
In my table or data I have fix date & fix time period ( hence Start date, Finish date , Start time and finish time is there). Once user enter any date & time I need to check two things only
1. Is the entered date between start date & finish date
2. Is the entered time between start time & finish time
If both are true then query will return me one row and I have another column in table called "energy factor" which has different value for different date & time range which I need to pick.
Please help me here. :banghead: