How do I...? 2

[CIMTEET]

How do I return all records in a table based on one field. Ex. Return all records that have someone who was has red hair. Assuming their is a hair color field. (I know, stupid example but I hope it gets the point across) I am using an ADO control to connect to the database. Please Help!!

Greg

 

[ToeShot]

in the criteria section of your query type "Red" under the hair field.

 

[THoey]

Or:

SELECT *
FROM MyTable
WHERE MyTable.HairColor = 'RED' Terry M. Hoey

 

[CIMTEET]

Would you guys by chance know the syntax for a connection string. I am trying to connect not using an ADO control.

Greg