Compare one record to many others

[TSO456]

Hi

I have an access table with 2 columns. I would like to compare each record in column one to all the records in column two. If any record in column one is less than column two then produce a report with the records that meet the criteria.

Thank you
Jill

 

[PHV]

Something like this ?
SELECT DISTINCT A.Col1, A.Col2
FROM myTable A INNER JOIN myTable B ON A.Col1 < B.Col2;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TSO456]

Hi PH

I need a VBA code that does that. A SQL query will not work.

Thank you
Jill

 

[PHV]

A SQL query will not work
??? Why ???

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244