Query Help

[whjwilson]

I am trying to run a query where I can pull entries that have a certain field. For instance my database tracks companys that are inspected and who conducted the inspection. I want to be able to go in and pull the list of inspections conducted an individual.

Company Inspected By
A Co. George
B Co. Will
C Co George
D Co Ron / George

How would I set it up to pull all inspections conducted by
George?

 

[PHV]

Something like this (SQL code)?
SELECT * FROM yourTable WHERE [Inspected By] Like '*George*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[whjwilson]

PH, thanks code worked great.