NEWBIE insert data rather than update in db

I have an app for tracking mileage on company vehicles. On the first form
you select a vehicle(via combobox getting vehicle names from database) and
enter the appropriate info. Then I need to export that data back to the
database. The ? is how do I update each vehicles info without it replacing
any prior info. I want the table to look like this after I export the data.

field1 field2 field3 field4 field5
Vehicle name Date Miles Gallons of Gas MPG
1 1-1-05 100 10 10
1-8-05 200 20 10
2 1-1-05 100 10 10

For a reference guide on SQL statements see the SQL Reference Guide:
<a rel="nofollow" style='text-decoration: none;' href="http://www.veign.com/vrc_app_main.asp" target="_blank">http://www.veign.com/vrc_app_main.asp</a>

Also, You asked a questions as a newbie so I'm not sure if you are familiar
with ADO. Are you?

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
<a rel="nofollow" style='text-decoration: none;' href="http://www.veign.com/vrc_main.asp" target="_blank">http://www.veign.com/vrc_main.asp</a>
--

"Mike & Dyan" wrote in message

 > I have an app for tracking mileage on company vehicles. On the first form
 > you select a vehicle(via combobox getting vehicle names from database) and
 > enter the appropriate info. Then I need to export that data back to the
 > database. The ? is how do I update each vehicles info without it replacing
 > any prior info. I want the table to look like this after I export the
data.
 >
 > field1 field2 field3 field4 field5
 > Vehicle name Date Miles Gallons of Gas MPG
 > 1 1-1-05 100 10 10
 > 1-8-05 200 20 10
 > 2 1-1-05 100 10 10
 >
 >