Limit information on report based on "Count"

[Drifter]

Hi

I have the following data in a table:

From To
a to b
a to b
a to c
b to c
b to c
etc etc etc

On a report I have a function that counts the number of instances from a to b, a to c etc. I want to limit the report to show only records where the count is above a certain value. For example in the above example a to c only occurs once so I want to discard that data in my report.

I guess that the data has to be filtered somehow in a query but have not idea how to do this.

Thanks for any help.

[MMcCarthy]

Assuming your data is stored like this ...

 
 From        To
a            b
a            b
a            c
b            c
b            c
 
 

SELECT From, To, Count([From] & [To]) As countInstance
FROM tableName
WHERE Count([From] & [To]) >1;