how to add records to a current table using an append query?

[Maxjoo]

Hello, every-1!!!!!...

I want to add the records from a second table to the main table using an append query, but every time I run the query a error appears, "an INSERT INTO query can not contain a multi-valued field". How can I solve this issue?. Thank You in advance!!!!

[mike60smart]

Hi
It is recommended not to use Multi-Valued fields.

[Maxjoo]

I eliminated the Multi-Valued fields, but the error keeps showing up...

[mike60smart]

Can you upload the SQL for the append?

[Maxjoo]

INSERT INTO tblMaintenanceDetails_Backup ( [BUILDING NAME], [UNIT NUMBER], [DESIGN (BED/BATH)], [ORDER DATE], [WORK ORDERED], CLEANING, [DATE FINISHED], [ENVOICE NUMBER], [ADITIONAL SERVICE] )
SELECT [301 N CHARLES].[BUILDING NAME], [301 N CHARLES].[UNIT NUMBER], [301 N CHARLES].[DESIGN (BED/BATH)], [301 N CHARLES].[DATE ORDERED], [301 N CHARLES].[WORK ORDER], [301 N CHARLES].CLEANING, [301 N CHARLES].[DATE FINISHED], [301 N CHARLES].[ENVOICE NUMBER], [301 N CHARLES].[ADITIONAL SERVICE]
FROM [301 N CHARLES];

[orange]

Max,
How about giving readers the 30,000 ft overview of your application? The who, what, where, when, how much and how often to provide some context...... may help with communications.

[Welshgasman]

I eliminated the Multi-Valued fields, but the error keeps showing up...

Well there must be one in there somewhere?
I am thinking that your db is not normalised going by the name of the source table?
Do you have a table for each building?

[madpiet]

INSERT INTO tblMaintenanceDetails_Backup ( [BUILDING NAME], [UNIT NUMBER], [DESIGN (BED/BATH)], [ORDER DATE], [WORK ORDERED], CLEANING, [DATE FINISHED], [ENVOICE NUMBER], [ADITIONAL SERVICE] )
SELECT [301 N CHARLES].[BUILDING NAME], [301 N CHARLES].[UNIT NUMBER], [301 N CHARLES].[DESIGN (BED/BATH)], [301 N CHARLES].[DATE ORDERED], [301 N CHARLES].[WORK ORDER], [301 N CHARLES].CLEANING, [301 N CHARLES].[DATE FINISHED], [301 N CHARLES].[ENVOICE NUMBER], [301 N CHARLES].[ADITIONAL SERVICE]
FROM [301 N CHARLES];

Are the values from your SELECT statement from columns in your table or are they literal values? if they're literal values, then they should be either in single quotes 'like this' (for strings) and no delimiter for numbers. It's not completely clear which you're intending.

Also, if you don't have a WHERE clause on your [301 N Charles] table, all of the records in that table will be appended to the tblMaintenanceDetails_backup table. Is that what you mean to do?