I'm using the Calendar Seminar lessons to learn how design and use a calendar in my db but I've run into a problem.  The code below works to find only zero hour entries and it finds them

SELECT CalendarID, ApptTime, Description FROM Q_DateTime WHERE DateTime=Forms!F_DatePicker!StartDate ORDER BY Q_DateTime.ApptTime;

but when I adjust the code to below it does't show any records at all.

SELECT CalendarID, ApptTime, Description FROM Q_DateTime WHERE DateTime>=Forms!F_DatePicker!StartDate AND DateTime
I am using 2010 if that matters

---

Reply from Alex Hedley:

You need to compare it with something:

SELECT CalendarID, ApptTime, Description FROM Q_DateTime WHERE DateTime>=Forms!F_DatePicker!StartDate AND DateTime

SELECT * FROM x WHERE DateTime >= y AND DateTime < z

If you replaced yours with sample values you'd have
SELECT CalendarID, ApptTime, Description FROM Q_DateTime WHERE DateTime>=#1/1/15# AND DateTime
=>
SELECT * FROM x WHERE DateTime >= #1/1/15# AND DateTime < #1/1/16#