display record if any field contains a certain value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

basically i have a table consisting of records that contain a date, location,
contract #, and a few more fields containing initials (initials could appear
more than once).

I just want a query that will display all the records in which a certain set
of initials are ANYWHERE in that particular record. for example purposes ill
use the initals "JLG". this is what i want to do.

for (i=0; i < # of Records ; i++)
if (any field in Record = "JLG")
Display this record in the query

does this make any sense?
thanks!
 
i actually answered my own question this is what i needed:


SELECT [Start Up].*
FROM [Start Up]
WHERE ((([Start Up].[Pre-Ship Setup])="JLG") OR (([Start Up].[Pre-Ship Setup
2])="JLG") OR (([Start Up].[Plant Install])="JLG") ........);
 
Back
Top