Complex report (1 Viewer)

Hi,

I'm creating a reporting format from a table. In the table i have 3 columns: A) Machine number, B) Alarm Number and C) Alarm Time.

Each machine has a set of alarms that trigger at certain time values (e.g. 12/15/2008 11:53:45 PM). Different alarms can occur at the same time (machine number: 08; alarm number: 100, 101, 102, 103; alarm time (for all of the alarms): 12/15/2008 11:53:45 PM.

I am developing a report that must filter the table with certains conditions:
1) Filter alarms by day (already done)
2) Filter alarms by minute: 11:53:45 PM (already done)
3) Filter alarms by frquency: if number 2) has one alarm only, it must not display the alarm or the machine, but if it has more than 2 alarms per machine, it must display the alarms triggered per machine.

This last filter is the one that I don't know how to do. I appreciate any help.

Thank you

Group by machine and creat a count field of alarm time in the query and set the criterea to condition

Where count([alarm time])>2