Long Text Fields Appearing as Gibberish in Query (1 Viewer)

P

PaulA

Registered User.

Local time

Today, 09:35

Joined

Jul 17, 2001

Messages

416

• Jan 15, 2018

• #1

I am runing a guery with multiple tables. One table has two long-text fields and when I run the query, they appear as gibberish symbols. They were working OK previous but now I can't get them to display the actual text.

Any ideas?

See attached image.

Thanks!

 

Attachments

• 
  Image.jpg

  95.8 KB · Views: 203

NauticalGent

Ignore List Poster Boy

Local time

Today, 04:35

Joined

Apr 27, 2015

Messages

6,321

• Jan 15, 2018

• #2

Can you post a picture of the query design grid?

 

P

PaulA

Registered User.

Local time

Today, 09:35

Joined

Jul 17, 2001

Messages

416

• Jan 15, 2018

• #3

Here you go. The fields are from the larger table on the right and are blackened below.

 

Attachments

• 
  image2.jpg

  96.5 KB · Views: 165

NauticalGent

Ignore List Poster Boy

Local time

Today, 04:35

Joined

Apr 27, 2015

Messages

6,321

• Jan 15, 2018

• #4

Try changing the Total line from Group By to First for the fields in question.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 16:35

Joined

May 7, 2009

Messages

19,232

• Jan 15, 2018

• #5

Check the table in design view if you fornatted the textbox as Richtext.

 

P

PaulA

Registered User.

Local time

Today, 09:35

Joined

Jul 17, 2001

Messages

416

• Jan 15, 2018

• #6

Changing from Group By to First did the trick.

Thanks!

 

NauticalGent

Ignore List Poster Boy

Local time

Today, 04:35

Joined

Apr 27, 2015

Messages

6,321

• Jan 15, 2018

• #7

Glad I could help!