I am querying 18 Fields named 1 to 18 - Now i should only be returning any of those fields with Kitchen range in the named cells - Unfortunately i am still returning some other suppliers in the fields 1 to 18.
I just cant understand why -as when i only query Customer_1 for "Kitchen Range" the query works perfectly.
Sometimes with the jet it will reparse a query differently than intended by the developer if it is done in the QBE window. This usually only happens with complex criteria.
If you are using pure SQL then the example I gave you earlier will yield the result set posted above. If you are getting results that include something other than kitchen range in the customer and customer_2 field then check the basics. Is this the only criteria being used and if so, is it all on the same line in the QBE window?
If you are using the QBE window, things on the same line are ANDs and things on different lines are ORs.
Just post the three fields that are part of the criteria your query (like I did eariler)
Show some examples of what your data looks like
And show what you want the query to bring back.
I'm not saying your lasy, but if you really want help, you have to provide what we need to help you, in your case it is sample data. You can also post you Dataset in mdb or xls (within a zipped file) through the use of attachements.