Samle to kolonner i en

SELECT .... [table1]![CPR] & [table2]![CPR] AS CPR FROM .....

Do I need to join my tables terry?

Ahh okay to elaborate my problem:

Table1 - CPR Coloumn (1 Row):
0123456789

Table2 - CPR Coloumn (3 Rows):
9876543210
8765432109
7654321087

Joined Table (4 Rows):
0123456789
9876543210
8765432109
7654321087

If I did it your way - I got:

Joined Table (3 Rows):
01234567899876543210
01234567898765432109
01234567897654321087

"Jeg har en access forespørgsel hvor jeg har CPR Numre fra 2 tabeller"

Depends how one understands your question.

But now I see the data you have in your tables then I think this is waht you are after.

SELECT CPR FROM Table1
UNION
SELECT CPR FROM Table2

and if you want to see all CPR if the same CPR is in both tables then use

UNION ALL

Yeah - Thats why the elaboration. I realized that I explained poorly.

Apart from that...YES! That was exactly what I needed and my "program" works like a charm now. Thank you yet again... (Since its not the first time you've helped me)

and thank you yet again too