Combining 2 Tables

[bsimonian]

Hello all you MS-Access geniuses! I'm fairly new to Access and I'm trying to manage a large amount of data from various sources that I need to bring into one collated table. Here's how it's setup as an example:

• Master_Table: date, data1, data2, data3
• Data1_Table: date1, data1
• Data2_Table: date2, data2
• Data3_Table: date3, data3

The "date" variable has all the dates for this calendar year. "date1", "date2", "date3" all have dates in the same range as "date" but there are some days/data points missing. So what I'm trying to do is combined all the info in Data1_Table, Data2_Table, and Data3_Table into Master_Table. There will be missing data for various dates in the master table for each of data1/2/3 so I just want them to appear as blanks.



I hope this makes sense and you guys can help me out with a query to get this rolling.

Thanks in advance!

[June7]

I am not sure the Master table is normalized. Are the 3 Data fields for the same kind of data?

Need a dataset of all possible dates. A UNION can do that.

SELECT Date1 AS RecordDate FROM Data1_Table
UNION SELECT Date2 FROM Data2_Table
UNION SELECT Date3 FROM Data3_Table;

Now build another query that joins the 3 tables to the UNION query.