I am very new to Access but I am needing to querry between two tables. This is my basic scenario:
Table 1
Policy ------ EffDate --------- Amount
1 ---------- 2/11 ---------- 5
2 ---------- 3/11 ---------- 6
3 ---------- 4/11 ---------- 7
4 ---------- 5/11 ---------- 8
5 ---------- 6/11 ---------- 9
6 ---------- 7/11 ---------- 4
In this table my Primary Key is Policy, the numbers never repeat
Table 2
Policy ------- RateDate -------- term
1 ------------ 2/11 ---------3
1 ------------ 3/11 ---------4
1 ------------ 3/11 ---------5
2 ------------ 3/11 ---------6
2 ------------ 4/11 ---------7
4 ------------ 5/11 ---------8
5 ------------ 6/11 ---------9
In this Table my Primary Key is Term, but i do not care about it. What I am looking to do is to gather the times that the Policy numbers are the same at the same time that the Dates are the same, it would look something like this:
Policy--------Date
1----------- 2/11
2 ---------- 3/11
4 ---------- 5/11
5 ---------- 6/11
Any help is very much appretiated. Thanks