I am using this Select statement to run this query in both Access and Excel VBA to open multiple records but having no luck:

```
Select * From tmDates where (Barcode = 100504339) and (Barcode = 100509738)

```

If I search one barcode it will work but not for two or more. Barcode is a PK in the table not sure if that has anything to do with it.

Any ideas?

Thanks,
Rogelio