Query not returning correct results

[Abbos]

Hi everyone,

I'm having an issue with a query I created. When run the query requests an Artist Name. I enter this and it returns one result. However in actual table ther are two results for that artist. The only difference is that for the record that doesnt appear the field labelled "Gallery" has a zero value.

I have checked the table and the gallery field is not set to a required field so I dont understand why it wont show it as a result of the query.

Any ideas?

 

[llkhoutx]

Fields have to be exacly alike. It not clear where the "zero" is. Use

Like "*Artist Name*" in your query.

 

[Abbos]

I tried what I thought was right but it wasn't returning the correct results.

Currently in my query, the criteria for the ArtistName field is:

[Forms]![Artist1]![ArtistName]

The ArtistName on the form is simply a textbox.

Does that help?

 

[Pat Hartman]

I would guess that the Artist names in the two records have a different number of spaces separating them.

Pat Hartman
Pat  Hartman