Need a bit of help.
Each day I work a PO Agenda spreadsheet. I would like to takethe comments from the spreadsheet I work today and move it to the spreadsheet Iwill work the next day. I created a selectquery to accomplish this task. However,when I change my select query to an update query I am having a problem updatingthe new PO Agenda. I am having troublewith the syntax in the Update to: field of my query.
Table Agenda is my new table.
PartNumber DocumentNumber Comments
Table OldAgenda is my old table with comments
PartNumber DocumentNumber Comments 111222333 FB600345005021 ContactedBuyer 9/8/2018 444555666 FZ607801248009 777888999 FE900165017280 RefurbishedValves on VSR
The Query works fine with the syntax below. There is a relationship between each field inboth tables.
SELECT [Old Agenda].HOME_ADDRESS
FROM [Old Agenda]
WHERE ((([Old Agenda].Comments) Is Not Null));
FIELD: Comments
Table: Old Agenda
Criteria: Is Not Null
Now when I change the Query to an Update Query the data doesnot transfer from “Old Agenda” table to the “Agenda” table when I use thefollowing info.
PartNumberDocumentNumber Comments 111222333 FB600345005021 ContactedBuyer 9/8/2018777888999 FE900165017280 RefurbishedValves on VSR
Field: Comments
Table: Old Agenda
Update: [Agenda]
Criteria: Is Not Null
or
Field: Comments
Table: Old Agenda
Update: [Agenda].[Comments]
Criteria: Is Not Null
Any help to get the correct Syntax for the Update: field will be appreciated.