Query to table question...

[Guest]

I am running a query on a current table. This query renames the titles for
the fields to eliminate spaces. What I am wondering - can a query create a
table that constantly gets updated. I understand there is an 'update query'
but it does not factor in new entries, or at least that's my understanding.

So what I want to do - take a query from a table and create a new table that
can be updated constantly by the query.

The shipping company I am trying to work with can only ODBC tables - which
makes no sense to me - but a query just won't work for them apparently.

 

[Guest]

You will have to use two queries. One to do the append and the other to do
the Update. Append queries do not operate on existing records and update
queries only update existing records. One note to remember is that an Append
query will throw an error if it tries to insert an existing value in a field
that must be unique or if it violates any other table or field validation
rules.