Query issue

[RayMilhon]

I have a query in MS Access 2010 that is giving me some strange results. Hoping Someone has an idea why this is happening.

There's a screenshot of one column of my query it's the only column that's doing this.





Here's the same column the only change made is I added a Group By



Anybody have a solution or an explanation as to why this is happening????

[jwhite]

This is a known bug (http://allenbrowne.com/bug-18.html) when attempting to GROUP BY on a Memo field. Does your query include such? If so, remove the group by on the memo field(s).

[RayMilhon]

yes it did not sure why. Thanks that corrected it.