Hi Jim

what would be the SQL logic to Select only records where there were more than one meeting the criteria

Answer : Use DISTINCT in the SQL statement.

That doesn't exclude the record for Jim

That wasn't the question you asked. You should use WHERE in the SQL Statement to define the condition that records must meet to be included in the returned data.
For Example :

Where Field1 = "John"

or

Where Field1 != "Jim"

Regards,

Liam




>Liam,
>
>That doesn't exclude the record for Jim.
>
>Renoir
>
>
>>Hi Renoir,
>>
>>Use DISTINCT in the SQL statement.
>>
>>Regards,
>>
>>Liam
>>
>>>I can easily do this with 2 statements, but what would be the SQL logic to Select only records where there were more than one meeting the criteria:
>>>
>>>

>>>MyField1     MyField2
>>>========     ========
>>>John         12345
>>>Jim          98765
>>>John         12345
>>>

>>>
>>>I only want this as a result:
>>>
>>>

>>>John         12345
>>>

>>>
>>>I only want 1 record with John and do not want Jim at all.
>>>
>>>Thanks, Renoir