Appending records to a table

[crowegreg]

Based on SQL string, I'm appending records to a table. How do I add,to my SQL string that I'd like to insert the text "New ID" into another field within the table that is being appended? Here is my SQL string:



INSERT INTO PM_Audit ( Position_ID )
SELECT PM_Current.Position_ID
FROM PM_ARCHIVE_130802 RIGHT JOIN PM_Current ON PM_ARCHIVE_130802.Position_ID = PM_Current.Position_ID
WHERE (((PM_ARCHIVE_130802.Position_ID) Is Null))

So, within table PM_Audit, I have a field named "Activity." I'd like to have "New ID" inserted into that field for these records.

Thank you in advance!!

[June7]

Your issue seems to be the same as https://www.accessforums.net/access/...ery-37060.html

If not, how do you generate this "New ID", where does it come from - on a form? Maybe:

INSERT INTO PM_Audit ( Position_ID, Activity )
SELECT PM_Current.Position_ID, Forms!formname!ID AS Activity
FROM PM_ARCHIVE_130802 RIGHT JOIN PM_Current ON PM_ARCHIVE_130802.Position_ID = PM_Current.Position_ID
WHERE (((PM_ARCHIVE_130802.Position_ID) Is Null))

[crowegreg]

Based on the FROM and WHERE part of this SQL statement, these are new records. When these records are inserted into the table, I need to also insert "New ID" into another field within that table. "New ID" is not coming from any form.

[June7]

Then where does it come from?

[crowegreg]

It's a label. I'm just trying to identify within this table that these are "New ID". I could label it anything.

[June7]

You want the literal text "New ID" in the Activity field? That's soooooo simple.


INSERT INTO PM_Audit ( Position_ID, Activity )
SELECT PM_Current.Position_ID, "New ID" AS Activity
FROM PM_ARCHIVE_130802 RIGHT JOIN PM_Current ON PM_ARCHIVE_130802.Position_ID = PM_Current.Position_ID
WHERE (((PM_ARCHIVE_130802.Position_ID) Is Null))

[crowegreg]

Perfect!! Just what I wanted. Thanks for your assistance!!