http://vbahowto.com Find out how to load a table into a recordset, loop through the records, and vba calculate 2 fields. Also how to make a user defined function and call it from a query.

The Database and code at the vbahowto blog – here: http://vbahowto.com/2012/12/31/vba-calculate-multiply/

Need to know how to insert into a table? See this video – http://www.youtube.com/watch?v=JnszX9kjFMk

Please take the opportunity to connect and share this video with your friends and family if you find it useful.