Union Query with missing values from one table

[JayDee]

I have the following Union Query



SELECT TblRegnskap.KundeNr, TblRegnskap.Konto, TblRegnskap.År, TblRegnskap.Periode, "Regnskap" AS Type
FROM TblRegnskap
GROUP BY TblRegnskap.KundeNr, TblRegnskap.Konto, TblRegnskap.År, TblRegnskap.Periode
UNION SELECT TblBudsjett2.KundeNr, TblBudsjett2.Konto, TblBudsjett2.År, TblBudsjett2.Periode, "Budsjett" AS Type
FROM TblBudsjett2
GROUP BY TblBudsjett2.KundeNr, TblBudsjett2.Konto, TblBudsjett2.År, TblBudsjett2.Periode;

When I run this query, the field [KundeNr] contains a symbol that looks like a paper clip and not the information from the field [Kundenr] in the table [TblBudsjett2]
This only happens on records from the [TblBudsjett2] not the [TblRegnskap]. Those records are fine.

What am I doing wrong.

[JoeM]

Is the Data Type for the KundeNr field in both tables exactly the same?
Are there entries for all records in this field for both tables?

[JayDee]

I checked, and it turns out that the type was Binary in one of the tables after a make table query. So after I corrected this it works fine.

many thanks