Help with UPDATE query

[Shaun]

Hi,

I have two columns in my Bookings table of type DATETIME -
Booking_Start_Date and Boking_End_Date. How can i update every row so that
all of the times for Booking_Start_Date are 09.00 and all of the times for
Booking_End_Date are 17.30, without affecting any of the dates?

Thanks for your help

[Rich P]

Add 2 more columns to your table: StartTime, EndTime, make them dateTime
fields. Then here is some code you can run

Sub UpdateTbl()
DoCmd.RunSql "Update yourTbl Set StartTime = #09:00#, " _
& "EndTime = #17:30#"
End Sub

Open up a standard module (Modules Tab) and paste this code in the
module (change yourTbl to the name of your table). While the cursor is
inbetween Sub UpdateTbl() and End Sub you can press F5 to run the code
(on works in Standard module - In a Form code module you can't use F5).
Note: you will get a message stating that ## Rows will be updated. Just
click yes to continue.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bob Quintal]

"Shaun" <sh***@mania.plus.com> wrote in
news:kd******************@wards.force9.net:

Hi,

I have two columns in my Bookings table of type DATETIME -
Booking_Start_Date and Boking_End_Date. How can i update every
row so that all of the times for Booking_Start_Date are 09.00
and all of the times for Booking_End_Date are 17.30, without
affecting any of the dates?

Thanks for your help

SET Booking_start_Date =
Dateserial(
year(booking_start_date),
month(booking_start_date),
Day(booking_start_date))
+timeserial(9,0,0)

HTH,

Bob Q