combine two datasets by ID and Date

i want to combine two datasets that look like this:

into one that looks like this

Sometimes for a certain date, there might not be an X and a Y value

in the end, I need a table/chart that allows me to filter for one ID and gives me all the X and Y data for said ID depending on their dates (months).

I am really new to the whole Access thing and am learning by doing. Couldn't find a way to do this by Googling, so any help is appreciated.

First, Use a union query to combine multiple queries into a single result:

Select ID, [Date], X As X1, 0 As Y2 From Dataset1
Union All 
Select ID, [Date], 0 As X1, Y As Y2 From Dataset2

Save it as DatasetU.

Next, use this in an aggregating query:

Select 
    DatasetU.ID, 
    DatasetU.[Date], 
    Sum(DatasetU.X1) AS X, 
    Sum(DatasetU.Y2) AS Y
From 
    DatasetU
Group By 
    DatasetU.ID, 
    DatasetU.[Date]

Output:

This is an option.

SELECT Table1.ID, Table1.Date, X, Y FROM Table2 
    RIGHT JOIN Table1 ON (Table2.Date = Table1.Date) AND (Table2.ID = Table1.ID)
UNION SELECT Table2.ID, Table2.Date, X, Y FROM Table1 
    RIGHT JOIN Table2 ON (Table1.Date = Table2.Date) AND (Table1.ID = Table2.ID);