Select Statement

[kmrowlan]

I am trying to filter a table (cmTable) based on a number field using a select statement. The number field has duplicates by design.

How can I filter using a where clause on a column that has duplicates?

Is there a work around that I need to do?

strSQL = "SELECT * From cmTable " & _
"WHERE (((cmTable.QuoteID)= '727'));"

 

[Norie]

What you've posted will filter for all records that meet the criteria no matter if they are duplicated.