Solved Need help getting append query working with a expression (1 Viewer)

[gojets1721]

I've got an append query that I'm trying to use to combine two telephone number fields into just one field. The code is below. For the life of me, I can't figure out why its not appending my table. It works fine as a select query. Both numbers are populated in the new expression field. But it won't append into the table. Any ideas? The new expression field is titled 'bothphones'

INSERT INTO RawList ( homephone, mobilephone, bothphones )
SELECT RawListTemp.[homephone], RawListTemp.[mobilephone], [homephone] & " " & [mobilephone] AS bothphones
FROM RawListTemp;

 

[theDBguy]

Can you post a sample db?

 

[June7]

Why duplicate phone data? Don't save the calculated bothphones value, calculate this when needed in query/form/report.

If bothphones is a calculated field in table, cannot update it, it is a calculation.

 

[gojets1721]

Why duplicate phone data? Don't save the calculated bothphones value, calculate this when needed in query/form/report.

If bothphones is a calculated field in table, cannot update it, it is a calculation.

I am very stupid. This is much easier lol. Thank you