#Name? What does this mean?

N

Novice2000

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
 
J

Jerry Whittle

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.
 
N

Novice2000

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.
 
J

Jerry Whittle

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.
 
Top