carlton123
Registered User.
- Local time
- Today, 07:53
- Joined
- Mar 18, 2011
- Messages
- 48
I have a SELECT stament which works
but when i add the WHERE
it doesn't work [TB_CAL_DATE] is a textbox with a Date in it any help would be great thanks
Code:
"SELECT Bookings_Table.Booking_Time, Bookings_Table.Num_Slots, Bookings_Table.Booking_Date FROM Bookings_Table ORDER BY Bookings_Table.Booking_Time;"
Code:
"SELECT Bookings_Table.Booking_Time, Bookings_Table.Num_Slots, Bookings_Table.Booking_Date FROM Bookings_Table WHERE (((Bookings_Table.Booking_Date)=[TB_CAL_DATE])) ORDER BY Bookings_Table.Booking_Time;"