Field turns text into symbols

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that I am running that changes the text into symbols. I have
tried deleting the field and I have deleted the table that I am getting the
data and re impoting it and when I look at the imported text in the table it
looks fine but when I use it in the query the text is converted to symbols.
Anyone know how to fix this?
 
Steve

Just in case the query is subtly corrupted, have you tried creating a new
query that returns that field?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks for your quick response. I rebuilt the query as you suggested but it
happened again. I started doing a process of elimination and discovered that
it is because I was using the totals in the query and it corrupted the memo
field when I did the Group By in the totals. I still have not figured out
how to get around that though.
 
Here is what I ultimately had to do. I had to change the memo field into a
text field. Unfortunately you are limited to 255 characters in a text field
but I would have had to build more queries jsut to get this one field to
work. I do not know if Microsoft has a solution or not. Thank you again for
your assistance. If you have another solution for me would you please let me
know?
 
Instead of Group By try using First on the memo field.
** First returns the value of the first memo from the first record in the
group that the engine finds. It is for practical purposes, essentially a
random record from the group (no order within the group).

Or use one of the substring functions Left or Mid to extract the first 255
characters and group by that if you really need to "Group" on the memo
field.
 
That worked. I used First. I needed to group the data to prevent duplication
from the two tables I was using to make the one final table. Thanks for your
help.
 
John, your response below saved me a ton of time and aggrevation. A big
thanks to you!

Rich
 
Back
Top