ok what you have to do is do an APPEND qyery. but thatwill change the value in your originating table as well. or if you want to have one more query. Create a form that pulls table from the table and do calculation on the form and save the result on a new query so that will have the result. Note: Do the calculation on the form text box not on the query.