Search Query

[Ben Williams]

Hi

I am after a way to do a search on 4 fields in one table,
so you have four fields that contain unique numbers and
when u do a search, it looks through all four columns to
find that number, then it will bring up the information,

any help is much appreciated

Thanks

Ben

 

[John Viescas]

Use the OR lines on the query design grid. The SQL will end up looking
like:

WHERE (Field1 = 55) OR (Field2 = 55) OR (Field3 = 55) OR (Field4 = 55)

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)