Its every field that changes. I guess it could be corrupt, but it still works
fine. I tried to build a new one from scratch, but it does the exact same
thing at the first one. It is connected through the Sequel Server to another
database.

"Jerry Whittle" wrote:

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.