For this you need to filter the recordset so only records where your field has the desired value will be returned:
SELECT * FROM test WHERE columnName = "value"
in the example above you will need to substitute the name of the column you wish to filter and the value you want to filter it on.