Search Query

  • Thread starter Thread starter Ben Williams
  • Start date Start date
B

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
 
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)
 
Back
Top