why access can not find that record??? (1 Viewer)

[Traden]

Hi,

i have a look up query and it works for all materials (approx. 2000) expect that description:

Large aluminium profiles WITH ACCESSORIES

Access even doesn`t find that one with the search funktion,

anyone knows why? If i enter Large* it finds it in search funktion, but when i copy paste the hole description form the table in the search it doesn`t find it why? are there any problems with the speeling and i need to set name restrictions?

thanks

 

[Oldsoftboss]

Eye Theenk ewe may av smelling problems.
(Only stirring)

Take a look at the attachment. may help to redesign your search engine to give greater user flexiiability

Try typing in a few different things into the "Supplier Of" field

HTH
Dave