SELECT Statement sought

[Micash]

Hi Guys
could someone help me with what might be quite a simple statement, but I am strggling with it.

I need to create a table that will populate with all the records that have two specified ID numbers.
I can do it to see a list of all records with one ID Number:
Example:
with datPeople
.Recordsource = "SELECT * FROM People WHERE IDNo =" & "'" & strID1 & "'"
.refresh
End With

I want to get a list showing records for strID1 and strID2
How is the statement sset up if possible
Regards
Micash

 

[Golom]

You can use

   .Recordsource = "SELECT * FROM People " & _
                   "WHERE IDNo ='" & strID1 & "' OR " & _
                   "      IDNo ='" & StrID2 & "'"

OR

   .Recordsource = "SELECT * FROM People " & _
                   "WHERE IDNo IN ('" & strID1 & "','"  & StrID2 &  "')"