Adding tables

[Gertjan]

Hello,

I'm using a query to add a table to another table, but i have problems
with the sorting

For example:

Table A has 20 records; record A - record T

Table B has 2 records; record 1 and record 2

When I add table A to B; I want the table to be like :
record 1
record 2
record A
record B
record C
record D
record E
record F
.....
record P
record Q
record R
record S
record T

BUT:
Sometimes the table is something like:
record Q
record R
record S
record T
record 1
record 2
record A
record B
record C
.....
record L
record M
record N
record O
record P

I can not sort the table, but the order of the added table should
remain.

Any ideas??



Gertjan

 

[Guest]

Tables are not sorted.

They can be indexed but you need to sort in your queries or via grouping and
sorting in a report.