I have a global table that houses a huge text import. I now want to extract some of that data based on a query into another table to do some work on it.
no,if you want to create a new table you would use the make table query,an append query will only add new records to an existing table.
to create a append query i first create a select query with
all the fields and criteria that i need
Then on the query menu bar you can change the query to an append query,you will be prompted to give the name of the table that you want to add the records to.Then all that needs to be done is select which field(s) in the table you want to store your new records
You can do the same sort of thing for a make table query
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.