Newbie sorting / lay-out question two tables / queries

[hanfrie]

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.

[Robl]

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 ()