D
DDogCap
I have a table that I copy and then want to append the original table to it
giving a new table with doubles of everything.
I copy the table then, I create a query using query wizard. I choose all
fields in my table. Then name it and go to Modify. I change it to an append
table and choose the copied table mentioned above. At this point, all of the
fields listed on the "Append To:" row have brackets around them the Append
Query doesn't run correctly. I have to manually strip the brackets from this
row and then the query works fine. Thoughts?
giving a new table with doubles of everything.
I copy the table then, I create a query using query wizard. I choose all
fields in my table. Then name it and go to Modify. I change it to an append
table and choose the copied table mentioned above. At this point, all of the
fields listed on the "Append To:" row have brackets around them the Append
Query doesn't run correctly. I have to manually strip the brackets from this
row and then the query works fine. Thoughts?