In this video you will find out how to load a table into a recordset object, loop through the records, and vba calculate 2 fields. Also you’ll find out how to make a user defined function and call it from a query.
Need to know how to insert into a table? See this video – MS Access SQL1
You can download the database file, by clicking here.