#Name?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
It's every field in the entire query that changes. It could be corrrupt I
guess, but it still works and I tried to build a new query and it still does
the same thing.
 
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.
 
Back
Top