You would probably be need to do something like:
Where Datediff('d', tblBooking.DateBooking , now()) >= 0
On Apr 3, 2005 4:15 PM, Jason Baird <[EMAIL PROTECTED]> wrote:
> 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 [email protected]
> To unsubscribe:
> http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
> To subscribe:
> http://www.dfwcfug.org/form_MemberRegistration.cfm
>
>
--
Invite 50 Friends to Gmail! Who has friggin' 50 friends!?
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
