T
Tom
I have a query that pulls the following fields from a
table.
Request_ID
Submitter
Person Assigned
Request Details (MEMO FIELD)
Email_Denial_Text (MEMO FIELD)
Denied
And has two WHERE statements based on these two fields
Status
Denied
I have two db's that are exactly the same except that in
one I was manually updating the table info and the other
does it automatically through an ODBC connection.
The DB that updates through the ODBC connection is having
a strange problem. When I run the query it turns the two
Memo Fields marked above into this "納&" rather than the
acual text that is in the table. But only when I include
the WHERE statements. If I take those out it works just
fine.
The DB that I have been manually updating with the same
info doesn't do this. Like I said they are exact
duplicates including the field names and all queries and
tables. The only difference is the ODBC connection.
Any ideas on how I might be able to fix this? I would
appreciate any help that can be offered.
Tom
table.
Request_ID
Submitter
Person Assigned
Request Details (MEMO FIELD)
Email_Denial_Text (MEMO FIELD)
Denied
And has two WHERE statements based on these two fields
Status
Denied
I have two db's that are exactly the same except that in
one I was manually updating the table info and the other
does it automatically through an ODBC connection.
The DB that updates through the ODBC connection is having
a strange problem. When I run the query it turns the two
Memo Fields marked above into this "納&" rather than the
acual text that is in the table. But only when I include
the WHERE statements. If I take those out it works just
fine.
The DB that I have been manually updating with the same
info doesn't do this. Like I said they are exact
duplicates including the field names and all queries and
tables. The only difference is the ODBC connection.
Any ideas on how I might be able to fix this? I would
appreciate any help that can be offered.
Tom