Ooo, thought I could help you until you said the word Access. Well, I'll try anyway. ;) The key is to strip the time values from the dates and then use a logical equals instead of a greater than/less than comparison.
Try this, WHERE Int(tblBooking.DateBooking) = Int(now()) Or maybe WHERE DateValue(tblBooking.DateBooking) = Int(now()) I forget exactly how those functions operate but that's what you need to use in one combination or another. - Daniel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, April 03, 2005 5:37 PM To: [email protected] Subject: RE: not giving me today on a SELECT Calendar day is fine. It is a simple Access database. > Do you want "today" as in calendar day or "today" as in a 24 hour window? > There's a big difference. > > What database server? > > What datatype is tblBooking.DateBooking? > > > - Daniel > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Jason Baird > Sent: Sunday, April 03, 2005 5:16 PM > To: [email protected] > Subject: not giving me today on a SELECT > > 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 > > > > ---------------------------------------------------------- > 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 > > > > ---------------------------------------------------------- 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 ---------------------------------------------------------- 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
