D
David McKnight
I have two tables
Table1 fields = [Yearof], [Company]
Table2 fields = [BeginYear],[EndYear], [President] ,[Company]
I would like to join both tables in a query so that the output would contain
the year and the company and the employee listed for the years between
BeginYear and EndYyear
query1 output=;
year company president
2003 USA George Bush
2002 USA George Bush
2001 USA Bill Clinton
2001 Texas George Bush
I have no idea how to do this but I have tried joining beginyear and
endyear to yearof but it does not work. Any ideas?
Table1 fields = [Yearof], [Company]
Table2 fields = [BeginYear],[EndYear], [President] ,[Company]
I would like to join both tables in a query so that the output would contain
the year and the company and the employee listed for the years between
BeginYear and EndYyear
query1 output=;
year company president
2003 USA George Bush
2002 USA George Bush
2001 USA Bill Clinton
2001 Texas George Bush
I have no idea how to do this but I have tried joining beginyear and
endyear to yearof but it does not work. Any ideas?