Weird characters in query results

[Pat]

I have an Access 2003 database that links to tables in an Oracle 9
database via ODBC. I have a form that I populate with data from the
Oracle DB, my users add other data to it, then the data that came from
Oracle plus the new data is saved to an Access table. I am
constructing a query against this table that groups data - here is the
SQL:

SELECT qryQuarterlyNonRevProjectResults.Type
, tblPSProjects.OEM, qryQuarterlyNonRevProjectResults.Year
, qryQuarterlyNonRevProjectResults.Quarter, Sum
(qryQuarterlyNonRevProjectResults.ActualHours) AS SumOfActualHours
, Sum((tblPSProjects.PMBudgetAmount+tblPSProjects.DesBudgetAmount
+tblPSProjects.DevBudgetAmount+tblPSProjects.IntBudgetAmount
+tblPSProjects.QABudgetAmount+tblPSProjects.PDBudgetAmount
+tblPSProjects.OtherBudgetAmount)) AS BudgetedHours
FROM qryQuarterlyNonRevProjectResults
INNER JOIN tblPSProjects ON
qryQuarterlyNonRevProjectResults.ProjectCode =
tblPSProjects.ProjectCode
GROUP BY qryQuarterlyNonRevProjectResults.Type, tblPSProjects.OEM,
qryQuarterlyNonRevProjectResults.Year,
qryQuarterlyNonRevProjectResults.Quarter;

When I execute this query, I the values that show up in my "OEM"
results column look like this: "ã°‰", "ã “", "å€","å„Ž", etc. These
values should be like "GM", or "Nissan".

Now, when I add a parameter to this query, like "HAVING
(((qryQuarterlyNonRevProjectResults.Year)=2009))" or "HAVING
(((tblPSProjects.OEM)="Nissan"))", the results view has the correct
values in the OEM column.

I have never seen anything like this before. There are no systems here
that would have foreign characters in them, so I can't see any reason
why these would ever show up.

 

[Pat]

Nevermind! I found this thread:
http://groups.google.com/group/micr...inese)+characters+in+results#bae6dc2a50af0dd4,
which described the same issue and a work-around that works in my
situation.