Query that will add the same sequence of Records...

[dillneus]

Hello,

As I am improving my Access skills recently, I have now another challenge...

I have couple of tables:
Region (IDRegion, IDCountry, CountryName, Region),
GDP (IDGDP, IDCountry, Country, Var, Unit, GDPgrowth, Source,Scenario),
Scenario (IDScenario, Scenario)
Source (IDSource, Source)

GDP is the main table here. There are data about every country from 1970 till 2005 about their GPD growth. It is for all countries, so lots of record... :)
(200 countries... so 200 records for 1970, 200 records for 1971 etc.)

These IDCountry is in relation with Region.IDRegion. IDScenario with GDP.Scenerio, IDSource with GDP.Source... all relation are one to many.

What I want to do is to add more years for the future for different scenarios in this table GDP.
Lets say:
I want to add years from 2006 till 2010. When I add year, i want to add every country for that year. if i add 2006, i want to add record with Afganistan 2006, France 2006 etc... so again adding many records. It would be for scenario A.
Then here i will assume some % for growth...

Then I want to add again in this 2006 till 2010 but now for scenario B.

I dont know how to do it properly. I would have it in one table (GDP) but if its neccesary i can split historical data with future. I tried with append query but i dont know how to add many records in the way i described above...

Do anyone have some ideas?

Greets
Greg

[Rabbit]

If you select two tables without joining them, it matches all records from one table to all the records in the other table. You already have a country table, you just need a table with the years you want to add.

[dillneus]

If you select two tables without joining them, it matches all records from one table to all the records in the other table. You already have a country table, you just need a table with the years you want to add.

ok thx it should work :)

[Rabbit]

Good luck.