SQL Plus - Insert statement

- maybe something like this?:

INSERT INTO table1 (field1, field2) SELECT field1, (field2 + 1) FROM table2

- if you can provide sample data, and how its being caculated it will much clearer. does the value came from a field in different table or the same table?

Qlemo,
I wish it were true that there is no reason to post my responses as an attachment, and that's precisely how I always initially respond. However, I don't know whether it's due to the extremely restrictive firewall under which I work, but I would say about 90% of the time I try to submit a direct response, it gets timed out, but an attachment will go through. This has been extremely frustrating to me as I have tried to submit solutions that were correct only to have to copy them to a file, save them and re-submit as an attachment only to have someone else get credit for submitting the same solution minutes earlier than my attachment. I expressed my displeasure with this a long time ago when EE made some substantial changes to the site causing my need to use the attachment method. I am trying to submit this comment directly now. Hopefully, it will go through.

I will return all answers and come back