I am trying to get a simple archive process working on a simple
database ( archiving data from a basic customer table) and I keep
getting this error message:

" The INSERT INTO statement contains the following unknown field name
'[First Name], make sure you typed correctly etc."

I have checked the queries find the data in a simple select query and
have then changed them to an Append/ Delete query which I am running
through a macro. The data is being added to an archive table which I
have created by changing the select table to a Make Table query. I
have aslo added to the macro SetWarnings False and set it as true
again at the end.

Here is the SQL code for the Append query- can anyone shed any light
on why I cannot get this to work?

INSERT INTO tblMember_Archive ( MemberID, [First Name], Surname, [Post
held], Address1, Address2, Address3, Postcode, [Telephone No], [Date
Joined], DOB )
SELECT tblMember.MemberID, tblMember.[First Name], tblMember.Surname,
tblMember.[Post held], tblMember.Address1, tblMember.Address2,
tblMember.Address3, tblMember.Postcode, tblMember.[Telephone No],
tblMember.[Date Joined], tblMember.DOB
FROM tblMember
WHERE (((tblMember.[Date Joined])<[Forms]![frmArchiveData]!
[txtArchiveDate]));

On Sun, 28 Nov 2010 07:14:33 -0800 (PST), Sue
<swbcteach (AT) googlemail (DOT) com> wrote:

Personally I never archive data but mark such records as inactive.
And all forms and reports respect that flag.

When it comes to customers I might mark them with a few different
statuses such as "business closed so never bother to contact them",
"customer didn't pay their last bill so don't deal with them." or "we
haven't heard from them for a while so still worth contacting every
year or so."

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

On Nov 28, 10:14*am, Sue <swbcte... (AT) googlemail (DOT) com> wrote:
Try a query similar to the following (after backing up the original
table) in order to narrow down the possibilities:

INSERT INTO tblMember_Archive ( MemberID, [First Name], Surname, [Post
held], Address1, Address2, Address3, Postcode, [Telephone No], [Date
Joined], DOB ) SELECT 11111, 'Jane', 'Doe', 'CFO', '123 Main', Null,
Null, '99999', '8005551212', #11/26/2010#, #5/5/1985#;

James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com