Devam Ediyor

Create a query to access to merge some tables.

I have 12 tables. The tables have the same format but from different periods. For example table 1 company ID, company subsidiary id ( a company could have many subsidiaries) [url removed, login to view] same for the second year etc.

I want to create a query to present company id company subsidiary year 2000, company subsidiary year 2001 and some other fields.

So in case there is the company x which in year 2000 have subsidiary x1 and x2

and in year 2001 has x1,x3,x4 I want the table to appear

ID SUBSIDIARY 2000 SUBSIDIARY 2001

X X1 X1

X X2 X3

X X4

and that I have to do it for all years. I tried to make the query but I have results like this

ID SUBSIDIARY 2000 SUBSIDIARY 2001

X X1 X1

X X1 X2

X X1 X3

X X2 X1

X X2 X2

X X2 X3

Beceriler: Veri Girişi

Daha fazlasını görün: x4, access query table, merge results, access table query, access merge table, access create query, create fake google results, create form merge access, create access query, query access, create tables relations access, create form post results, create tables access, create access tables, access table create, create form send results, access create table, create access table, create table access

İşveren Hakkında:
( 1 değerlendirme ) Norwich, United Kingdom

Proje NO: #6540170

Seçilen:

vsprybhanu

Hired by the Employer

1 gün içinde 20$ USD
(17 Değerlendirme)
3.8