Append Records from Main to Secondary Table

[jcbhydro]

Good Morning Folks,

With the help of this forum I built an Append Query to take records of 'Leavers' from my Primary Table and add them to a Secondary Table named 'Leavers. This worked perfectly, but on reflection I determined that I needed to append a further column 'Notes' which exists in the Main Table but not in the Secondary Table.
I amended the SQL statement as follows, but the query now fails stating that it doesn't recognize the field 'Notes'.

INSERT INTO Leavers ( [Member ID], Surname, [First Name], [Address 1], [Address 2], Town, PostCode, Phone, [E-Mail], Notes )
SELECT [Mail List].[Member ID], [Mail List].Surname, [Mail List].[First Name], [Mail List].[Address 1], [Mail List].[Address 2], [Mail List].Town, [Mail List].PostCode, [Mail List].Phone, [Mail List].[E-Mail], [Mail List].Notes
FROM [Mail List]
WHERE ((([Mail List].Leaving)=True));

Does this mean that one would need to recreate a new Secondary Table to incorporate the additional field? I have attempted to edit the secondary table by merely adding the 'Notes' field but that doesn't seem to be possible.

Any suggestions to alleviate my utter frustration would be welcome.

Regards,

jcbhydro

 

[JHB]

I have attempted to edit the secondary table by merely adding the 'Notes' field but that doesn't seem to be possible.

Why not, what happens?

 

[jcbhydro]

Thanks for your comment which prompted me to look again.

As you suggest adding a field to the secondary table is no problem unless one carelessly neglects to select 'Design View'.

jcbhdro

 

[JHB]

.. is no problem unless one carelessly neglects to select 'Design View'.

Yes, yes - no problem.