find

[smiller]

Is there any way I can do a search that lets me put in a section of a part number and the part number be found? I only see how I can find the number if I put in the entire number.

Thanks

 

[KenHigg]

I think you should be able to use an astrick to do this:

Part number: *999

Would find all part numbers with 999 at the far right side...

 

[smiller]

thanks...that works well in the find and replace. Is there any way I could do that for a query, though, so I can have all the data be pulled out of the huge table and seen only with the pieces of data I need. Thanks

 

[KenHigg]

It's basic query criteria - Not sure what the problem is... Or did I miss something?

 

[jkl0]

In the criteria of your part number field in your query use:

Like "*" & [Enter Part Number] & "*"