Tabel oversættelse

An idea would be to add a field (cpr) to the table "Før 2008"  and then run an update query to cpr with the cpr number from tbale CPR.

Example:

UPDATE [Før 2008] SET CPR = (SELECT CPR FROM [CPR] C WHERE C![Lønnummer] = [Før 2008]![lønnummer]


Now you have the cpr number in both tables

You could also do the same for the "Efter 2008" table so that you have "Lønnummer in that too.

Now both your tables should be the same, where you can choose to use either CPR or lønnummer.

you need a closing ) to the UPDATE SQL

Hmm I have thougth of that, but but but - in the futhure I have to import the list to Efter 2008, and I'm not finish importing the list Før 2008.
So an update is not the right choice at the moment.
I'm looking for a solution where the system is to find the cpr. number in the tabel Cpr nr. and if it dosn't have a number there - it just finds it in the tabel efter 2008

Best regards
Ida nielsen

Its difficult to give a solution without really knowing more to what exactly it is your trying to do.

"Altså jeg vil gerne have en forspørgsel som tager alle poster på et cpr nummer"

Are you saying that the same CPR/Lønnummer can be in both tables?

If so then make a UNION SELECT


SELECT .....
UNION
SELECT .....


you cant use query designer to make UNION selects but you can use it to get the SQL right for each seperate SELECT in the UNION select

so first get the select working for [Før 2008] using the CPR table to find the correct CP and then do then make a SELECT for the "EFTER 2008" table.

Just make sure that for each select you have the same number of output fields and with the same type.
You could actually make a query for each of these selects and then make teh UNION select with these..

EG:

SELECT * FROM qyFør2008
UNION
SELECT * FROM qyEfter2008

do you still need help here Ida?

thanks