Does that field use a function such as CDate, CStr, etc? If so the data hits
something that causes a problem for the function such as a null value. Post
the SQL and which field is causing problems.

Another possibility is that you have a corrupt database. Is the field in
question a Memo field by chance?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Novice2000" wrote:

Hi,

I created a query, and it seems to work fine and I am pulling data from it
to populate three reports. But, there is a weird thing that happens.

When I open the query in Datasheet view then scroll along to the right all
of the data suddenly becomes #Name?. What is this and is it something I can
repair? Thanks.