hello all,
It is quite possible that I ask something basic here, but I need some direction. I have the following situation: what I need is a report that holds two tables, and both tables may or may not share the same value regarding one column. So visually;
A
table 1 with columns (A) B C D E
table 2 with columns (A) F G H I
The display of both tables should be so, that tables 1 and 2 are sorted on the value of column A. Complicating factor: not all values of column A in table 1 are present in table 2 or vice versa. Both tables are filled by two different queries.
So suppose in table 1, column A has the values 1, 2 and 3.
In table 2, column A has the values 1, 3, 4. This would result in the following picture;
1
table 1 with columns A(=1) B C D E
table 2 with columns A(=1) F G H I
2
table 1with columns A(=2) B C D E
3
table 1 with columns A(=3) B C D E
table 2 with columns A(=3) F G H I
4
table 2 with columns A(=4) F G H I
How could I achieve above picture, in which two different tables are shown below each other and sorted on there common value of one column?
Your help is much appreciated.
I can't follow exactly what you want;
But I think it's this;
Make two query subjects, for table 1 and table 2.
Double sided outer join them on column A.
This will give you a single new query with columns
A A1 B C D E F G H I
(there are two instance of A, one from each table)
Run that report, make sure it works.
Then make a new column of
A
If ([A] is null) then ([A1]) else ([A])
Then it's just a case of building data items like;
Column 2
If ( is null) then ([F]) else ()