make table query

[munday63]

hi

i have a make table query which stores the data i require, but what i want is it to store the data that is usually overwritten every time the make table query is ran. It always gets deleted when i need to keep that data as well as the new data.

Any ideas?

 

[ColinEssex]

use an append query

Col