Access replaces text with weird symbols

  • Thread starter Thread starter davidmflanders
  • Start date Start date
D

davidmflanders

Hello All,
I've created a query, but when I run the query Access replaces the
words from the table with symbols like these: ë…“ , êœ , 鬊 , è±… , etc.

Does anyone know how to make Access stop doing this and show the
actual text that I'm pulling off of the tables?

Thanks so much & sorry if this is something basic--still learning here.
 
Hello All,
I've created a query, but when I run the query Access replaces the
words from the table with symbols like these: ? , ? , ? , ? , etc.

Does anyone know how to make Access stop doing this and show the
actual text that I'm pulling off of the tables?

Thanks so much & sorry if this is something basic--still learning here.
Click to expand...

My very strong guess is that you're trying to display a Lookup Field. What
you're seeing is the ASCII equivalent of the numeric ID which is what is
REALLY in your table, concealed from your view by Microsoft's misdesigned,
misleading, infuriating Lookup Wizard. If so you need to join the Lookup Table
to the query, and pull the word from the lookup table (the only place where
the word is actually stored).

Perhaps you could post the datatypes of your fields and the SQL view of the
query.
 
The other possibility is that you have some corruped records in your
table.

Go to the actual table and view the records. If you see a record that
displays those types of characters in a number of the fields, try to
change the record. If you get an error message, that is an indication
that your table/mdb file is corrupt and you need to run a compact and
repair. And then you need to go back and delete the record.

If you don't get a message, then it still was probably a corrupt
record but you have already run a compact and repair since the time
that the record was coreated.

Typically corrupt records will NOT have enough information in them to
reconstruct the original information. If it does then you can decide
what you want to do (fix that record or delete and re-enter) The
problem with both approaches is if you have child tables that are
linked with this table via IDs you may end up with orphan child
records.

Good Luck.

Ron
 
My very strong guess is that you're trying to display a Lookup Field. What
you're seeing is the ASCII equivalent of the numeric ID which is what is
REALLY in your table, concealed from your view by Microsoft's misdesigned,
misleading, infuriating Lookup Wizard. If so you need to join the Lookup Table
to the query, and pull the word from the lookup table (the only place where
the word is actually stored).

Perhaps you could post the datatypes of your fields and the SQL view of the
query.
Click to expand...

Hi John,
The query is as follows:

SELECT Application.LastName, Application.FirstName,
Application.MiddleName, JobPosting.PostingTitle, JobPosting.Location,
Application.ApplicationID, ApplicationTwoPartResponse.selectedResponse
FROM ApplicationTwoPartResponse INNER JOIN (JobPosting RIGHT JOIN
(PositionStatusHistory INNER JOIN (Application INNER JOIN [Position]
ON Application.ApplicationID = Position.applicationID) ON
PositionStatusHistory.positionID = Position.positionID) ON
JobPosting.PostingID = Position.postingID) ON
ApplicationTwoPartResponse.applicationID = Application.ApplicationID
WHERE (((PositionStatusHistory.createDate) Between [Start Date] And
[End Date]))
GROUP BY Application.LastName, Application.FirstName,
Application.MiddleName, JobPosting.PostingTitle, JobPosting.Location,
Application.ApplicationID,
ApplicationTwoPartResponse.selectedResponse,
ApplicationTwoPartResponse.questionID,
PositionStatusHistory.positionStatusID
HAVING (((ApplicationTwoPartResponse.questionID)=2526) AND
((PositionStatusHistory.positionStatusID)=5));


The issue is with the field
"ApplicationTwoPartResponse.selectedResponse" which is a text field.
In other queries the text comes out just fine, but for some reason it
just doesn't work with this query.

Thanks in advance for your assistance, I certainly appreciate it.
David
 
I have had this happen to me too but have not figured out why or when.

I do know that it only did it where in a name field it had the characters
like:
ñ n



for some reason it replaced all text in the entire record with the symbols ?
, ? , ? , ?.



Craig




Hello All,
I've created a query, but when I run the query Access replaces the
words from the table with symbols like these: ? , ? , ? , ? , etc.

Does anyone know how to make Access stop doing this and show the
actual text that I'm pulling off of the tables?

Thanks so much & sorry if this is something basic--still learning here.
 
Back
Top