Looking for a particular value

[s.booth]

Have a table that carrys details of vehicles and want to create a querry that just sorts out the Fords.

The problem is the word Ford can be found anywhere in the vehicles description. Is there a way of just looking for a certain string ie Ford, that can be requested in the criteria of the querry that does not depend on the word being in a particular place in the vehicle details feild.

Thanks

 

[Mile-O]

Use the Like criteria:

i.e.

Like *Ford*

 

[Mile-O]

As an aside, it sounds as if your data is in violation of 1st Normal Form.

[rhetorical question] Shouldn't you really be having a field for vehicle make? [/rhetorical question]