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


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


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, create rank student position access query, access 2007 visual basic create pdf, query access, create form sends results database, create tables relations access, create form post results, access 2007 simple database create, 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



Hired by the Employer

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