Let me explain clearly,
4 tables connected in query. If you look at the data below ID( 2) is a duplicate one because it has got same records . And ID (3) has got two records but with different Dates So i want the report to only show the data assosciated with ID(3). Please Help me thank you.
ID exists in three tables (tbl1,tbl2,tbl3) all of them are linked by ID and tbl2 is linked to tbl4 by region .
So in the query results ID is pulled from tbl1 and region is also pulled from tbl4 and start date and end date is pullled from tbl3.
ID Start Date End Date Region
1 01/01/2010 02/01/2010 01
2 07/01/2010 08/01/2010 05
2 07/01/2010 08/01/2010 05
3 03/01/2010 04/01/2010 02
3 05/01/2010 06/01/2010 02
4 tables connected in query. If you look at the data below ID( 2) is a duplicate one because it has got same records . And ID (3) has got two records but with different Dates So i want the report to only show the data assosciated with ID(3). Please Help me thank you.
ID exists in three tables (tbl1,tbl2,tbl3) all of them are linked by ID and tbl2 is linked to tbl4 by region .
So in the query results ID is pulled from tbl1 and region is also pulled from tbl4 and start date and end date is pullled from tbl3.
ID Start Date End Date Region
1 01/01/2010 02/01/2010 01
2 07/01/2010 08/01/2010 05
2 07/01/2010 08/01/2010 05
3 03/01/2010 04/01/2010 02
3 05/01/2010 06/01/2010 02
