updating database
Article Writing
2
Posts
2
Posters
0
Views
1
Watching
-
how to update the last data. objConnection.Execute "UPDATE buffet_list SET buffet = 2500 WHERE order_id=???" wat should i put in place of the ??? to get the last order_id??? order_id is Autonumber aaa
SELECT MAX(order_id) FROM buffet_list and then you do the update, OR UPDATE buffet_list SET buffet = 2500 WHERE order_id IN( SELECT MAX(order_id) FROM buffet_list ) or some other flavour, but you get the idea. Andres Manggini. Buenos Aires - Argentina.