Make Table query with variable number of fields

B

Boris Zakharin

I have a make table query that combines data from two other tables. In it I
UNION three select statements. The first is a join of the two tables where
the information in the two tables overlaps, while the other two are the data
that does not overlap from each table respectively, with default values for
the rest of the fields. Now, the person I'm doing this for wants to add her
own fields as needed to one of the two tables involved and generate a new
table with the newly added fields using the same query. Is this possible? If
so, how?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Mismatch in Excel 2010 4
Nested query problem 6
Union and group, then count 1
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
Comparing two tables 6
Make table using Union Query 2
union queries - with tables containing fields with attachments 2
Changing Primary Key numbering format 1

Top