I have an application created in Access 97. I am currently pulling data from the Access database in <BR>my code module and making calculations with the data from the database. I am not having a problem with <BR>calculations, but I want to store the values in a temp table. What is the syntax to insert a variables <BR>value into the temp table. <BR>Example:<BR>strSQL = "SELECT Jobnumber, TimeUsed FROM PaymentInfo WHERE Jobnumber = '0111766'"<BR> Set paymentinfo = dbs.OpenRecordset(strSQL)<BR> Do While Not paymentinfo.EOF<BR> totalused = totalused + paymentinfo("timeused")<BR> paymentinfo.MoveNext<BR> Loop<BR>I want to insert the value of "totalused" into a temp table. Thanks in advance.