not giving me today on a SELECT

[Jason Baird]

THis select statement is not giving me records for today, and yes 
I  already checked my clock for the date, etc. How would I make it select 
entries starting from a day earlier than the day I execute the select 
statement?

SELECT tblBooking.DateBooking, tblReservation.EventName,
tblGroup.GroupName, (tblBooking.DateBooking +
tblBooking.TimeBookingStart) AS booking_start, (tblBooking.DateBooking +
tblBooking.TimeBookingEnd) AS booking_end, tblRoom.Description,
tblGroup.Contact, tblGroup.Phone
FROM ((tblReservation LEFT JOIN tblBooking ON tblBooking.ReservationID =
tblReservation.ID) LEFT JOIN tblGroup ON tblGroup.ID =
tblReservation.GroupID) LEFT JOIN tblRoom ON tblRoom.ID = tblBooking.RoomID
WHERE tblBooking.DateBooking >= now()
ORDER BY tblBooking.DateBooking, tblBooking.TimeBookingStart;
Jason Baird
http://www.weboutsourcing.com
214-570-8336 

----------------------------------------------------------
To post, send email to list@dfwcfug.org
To unsubscribe: 
  http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: 
  http://www.dfwcfug.org/form_MemberRegistration.cfm