Web Development

Ask something
Question Locked

Query in MS Access 2003

0 helpful
2 replies

by petevoni

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm am having a difficult time with a simple problem. I have queries in my parts databse that can search one field at a time with a wild card. I input the part number or portion of the part number and it returns all relevant records. I would like to modify this query to search more than one field within the same table (example; type in my search criteria and the query checks the part number fields, the third party part number fields, and the alternate part number fields. I've tried using various OR operators but I just can't seem to get the syntax down. Any suggestions?

2 replies

by tony hopkinson

Select * From Parts Where
PartNumber Like '%001%'
Or
ThirdPartyNumber Like '%002%'
[Or ...]
should work though access might use * instead of %, because the accepted international decades old standard was confusing Bill.

If I've completely misunderstood, we'd probably make more headway if you posted the sql.

This discussion is closed to new replies.