Weird: Union query turns number into character

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

Hello everyone,

I am confounded by this. I do a union query bringing together data from two
other queries. Everything works fine, except for records from one of the
queries (qryAffiliationCallTracking) it turns Contact ID into strange
characters - letters with accents, boxes. The kind of characters I'd go to
the Character Map to find.

Here is my query:

SELECT
[SAI_StaffID], [OrganizationHistoryID] AS [HistoryID], [OrganizationID],
[Date], [Notes], [KeyConnection?], [OrganizationName] AS [Interacted With],
[OrgOrAff], [OrgID], [ContactID] FROM [qryOrgCallTracking]

UNION SELECT
[SAI_StaffID], [ContactHistoryID] AS [HistoryID], [OrganizationID], [Date],
[Notes], [KeyConnection?], [NameAndOrg] AS [Interacted With], [OrgOrAff] ,
[OrgID], [ContactID] FROM [qryAffiliationCallTracking];


Many thanks in advance,

Matthew
 
Everything works fine, except for records from one of the
queries (qryAffiliationCallTracking) it turns Contact ID into strange
characters - letters with accents, boxes.
Click to expand...

What are the datatypes of ContactID in the two component queries? If
they are different you'll get this effect - they should either both be
numeric or both Text.
 
Back
Top