G
Guest
I want to show all records of "Falls" that occur between the hours of 11 pm
and 7 am (the night shift) for the dates of 1/1/07 and 3/31/07. I have
queried the dates fine but not the time. For the critera I typed: Between
11:00 pm and 7:00 am. But I get records that are between the hours of 7:00
am to 11:00 pm.
and 7 am (the night shift) for the dates of 1/1/07 and 3/31/07. I have
queried the dates fine but not the time. For the critera I typed: Between
11:00 pm and 7:00 am. But I get records that are between the hours of 7:00
am to 11:00 pm.