Hi



I am trying to do multiple UPDATES in a single query but it's giving me syntex error. Could you help. The code is like

UPDATE 5Min_Bus SET colTime = #12:05:00 AM#
WHERE Id BETWEEN 5765 AND 11528
UPDATE 5Min_Bus SET colTime = #12:10:00 AM#
WHERE Id BETWEEN 11529 AND 17292
.....
......
UPDATE 5Min_Bus SET colTime = #12:55:00 AM#
WHERE Id BETWEEN 52765 AND 63404


My access version is 2002