Make-Table Queries - Can table be Updated?

[lstantliff]

I have created my first Make-table query and it actually worked!!!Yeah! But now, is there a way to make this table updateable each time the query is run?

 

[KeithG]

What do you mean by that? If you go directly into the table you should be able to update the data.

 

[lstantliff]

When I tried to run the query again it just told me that the table already existed. This is a parameter query and result can change. Is there a way to make the table update each time the query is run? --Thanks!

 

[KeithG]

You can use an append query to append records to the table. If you want to delete all the records and then add new ones run a delete query before your append query.