How to Join sum the values in two tables in access?

[Rolandas]

Hello,

I would be reallu grateful if someone could answer my question. I have two tables. The first table is with date and value. The same is another. e.g.
Table 1:
Date | Value|
1/1/2010 | 10
2/1/2010 | 10
3/1/2010 | 10
4/1/2010 | 10
5/1/2010 | 10
6/1/2010 | 10
7/1/2010 | 10
8/1/2010 | 10
9/1/2010 | 10
10/1/2010 | 10

Table 2:
Date | Value
3/1/2010 | 4
8/1/2010 | -2

I need to get the answer like this:
1/1/2010 | 10
2/1/2010 | 10
3/1/2010 | 14
4/1/2010 | 14
5/1/2010 | 14
6/1/2010 | 14
7/1/2010 | 14
8/1/2010 | 12
9/1/2010 | 12
10/1/2010 | 12

I need to take all the date values from table 1. Then according to date values in table 2, add or substract it to the values of table 1.
Is it possible to do that?

[Rabbit]

Take the union all of the query and then do an aggregate from that.

[Rolandas]

Thanks for the answer, but what aggregate function do you mean? DSum? When I do that I get those rows sumed where the date is the same. But I need to hold that value for the next records as I explained with an example in the question.

[Rabbit]

I mean a regular sum query. You just need to join or union all the data first.

[Rolandas]

You see, if I use a regular sum query, I get such table

Date | Value|
1/1/2010 | 10
2/1/2010 | 10
3/1/2010 | 14
4/1/2010 | 10
5/1/2010 | 10
6/1/2010 | 10
7/1/2010 | 10
8/1/2010 | 8
9/1/2010 | 10
10/1/2010 | 10


I need to get this:
1/1/2010 | 10
2/1/2010 | 10
3/1/2010 | 14
4/1/2010 | 14
5/1/2010 | 14
6/1/2010 | 14
7/1/2010 | 14
8/1/2010 | 12
9/1/2010 | 12
10/1/2010 | 12

[Rabbit]

In that case, you'll need to use a subquery to select the sum of the records from the second table where the date is less than or equal to the date in the first table.