Merge tables and queries

[Alpi]

I would like some help on how I could merge several tables or queries creating one final table. So far I created a Union query with the fields I want from every table and query but I cannot add data manually in there. I have to go everytime to the original files and add the data there. I attach a sample of my database with the tables, queries and the Union Query. Any ideas?

Thanks!

 

[jDa]

I've often wondered why some queries won't let you enter data and others will. But for a union query, the reason is a little easier for me to understand: each column has data from several different sources...if the union query were to let you enter data directly, where would the data go? Which of the source tables would end up with it? The query isn't able to answer that question, so it can't let you enter the data.

You mentioned creating one final table. You could do this by creating a MakeTable query based on your union query. But I'm not sure from your post if this is what you really want. Say more...

 

[Alpi]

Is like you have two excel files with similar columns and and you copy-paste the columns of the one under the columns of the other so that you have one file with all the data from both. Then you can type whatever additional data you want in the large file. How can you do that in access? It would be great if I could have some advice and solve it this week.

Thanks a lot!

 

[jDa]

Okay, if you don't need the original sources to be updated with the additional data you enter in the large file, then the problem becomes very easy. You already have a union query, right? Then the next step is to open a new query, add your union query as the data source for the new query. Select every field. Now convert this new query into a Make-Table query. There should be an option on the toolbar to let you do this...if you have trouble finding it, consult Help under Make-Table. Once you run (!) this new query, you will find a new table has been created with all your data from the union query. You will be able to enter additional data into this table. However, none of your original tables will reflect the additional data...as I am understanding your post, this is okay. If not, let me know, and we'll look for a new approach.

Hope this helps...good luck!

 

[Alpi]

This is it . It worked fine. I hope I get over with it..
Thanks.