A table with two fields pointing to the same field in another table

[bg_ie]

Hi,

I have a table called Test. This table includes two fields called
"Start_Date_Name" and "Finish_Date_Name". These fields hold the
primary Id of a row in another table called Date_Properties, which has
a field called "Date_Name". Typical values for Date_Name include "Test
1, 2006"; "Test 5, 2007".

I wish to have a query which produces a table like this -

Test Name Start_Date_Name Finish_Date_Name
Barry's Test Test 1, 2006 Test 1, 2007
Barry's 2nd Test Test 4, 2006 Test 1, 2007
Liam's Test Test 1, 2005 Test 4, 2008

The problem is that I can't create this query in the Design View since
when I try to add Date_Properties.Date_Name as a field in my query,
Access can't tell whether this is concerned with Start_Date_Name or
Finish_Date_Name. How might I resolve this?

Thanks for your help,

Barry.

 

[bg_ie]

Hi,

I have a table called Test. This table includes two fields called
"Start_Date_Name" and "Finish_Date_Name". These fields hold the
primary Id of a row in another table called Date_Properties, which has
a field called "Date_Name". Typical values for Date_Name include "Test
1, 2006"; "Test 5, 2007".

I wish to have a query which produces a table like this -

Test Name Start_Date_Name Finish_Date_Name
Barry's Test Test 1, 2006 Test 1, 2007
Barry's 2nd Test Test 4, 2006 Test 1, 2007
Liam's Test Test 1, 2005 Test 4, 2008

The problem is that I can't create this query in the Design View since
when I try to add Date_Properties.Date_Name as a field in my query,
Access can't tell whether this is concerned with Start_Date_Name or
Finish_Date_Name. How might I resolve this?

Thanks for your help,

Barry.

Just figured this out. You need to add the same table twice in the
design view...