#Name? What does this mean?

G

Guest

Seen this out here before, but I have never seen an answer. What is this. I
have entered all of the criteria for a query, and it opens up, but when I
scroll across the columns I seem to reach one that casues all of the data in
all of the fields to be converted to #Name?. Thanks
 
G

Guest

Somewhere you've typed in the name of a field that isn't there at all or not
exactly right.

Other than that, maybe the database is corrupt. Do a Compact and Repair and
see if that fixes it.
 
G

Guest

The Compact and Repair didn't do it, but I removed one field called notes and
that seemed to stabilize the data. Thanks for your help.
 
G

Guest

I bet that Notes was a Memo data type. Memo fields are known to corrupt and
often compact and repair won't fix them. I avoid Memo fields for that reason
and make frequent backups when they are required.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 Query - what does this <> mean? 4
Excel Date Setting 1
Looking for Existing Records 2
"is not a valid name. Make sure 7
update a multivalued field access 2007 1
what does this mean? 5
Cannot see fields in query design view on laptop; Access 2003 1
query results show several "copies" of same record 8

Top