memo field showing "?" in query 1

[blindlemonray]

I have several tables in a query. One table contains a memo field. when the table is queried instead of showing the tables contents it shows ?.

I have tried quering just the table on its own and it shows the results as normal (i.e. the text from the memo field is displayed).

Any ideas?

 

[lameid]

Try these in this order:

Compact and repair your database.

Copy the SQL of the query and paste it into a new Query; Delete the old one if the new one works.

Post your SQL Code here.

 

[RoyVidar]

Could it be this

http://allenbrowne.com/bug-18.html

?

Roy-Vidar

 

[lameid]

Roy,

Good call. I've never hit that bug (probably because I wouldn't group on a memo field). That is star worthy... I hope the OP issue is solved.

 

[blindlemonray]

Hi RoyVidar,

That's exactly what i did to solve the issue. I was looking at the query and just playing to see what would change it and had to change it to first and not group by.

Absolutley spot om

Cheers
BLR