#Name? What does this mean?

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

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Novice2000" wrote:

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

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.

"Jerry Whittle" wrote:

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Novice2000" wrote:

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

it mean hi

"Novice2000" wrote:

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

Beg you pardon?

" wrote:

it mean hi

"Novice2000" wrote:

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

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Novice2000" wrote:

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.

"Jerry Whittle" wrote:

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Novice2000" wrote:

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