Hi everyone,
I new at Access and I'm dealing with a table that has 3 columns. The first column is a machine number (1-13), the second one is a list of alarm numbers, and the third one has the date & time in which the alarm number was triggered and recorded.
The alarms trigger whenever there's a failure. In many cases a single alarm displays a set of alarms. If this happens, the alrms triggered and recorded have the same date & time. Therefore, I need to know the number of times a group of alarms has been triggered. I can't do this in excel because I have more than 500,000 records.
Is there a way to this without doing it manually?
Thanks for your help.
I new at Access and I'm dealing with a table that has 3 columns. The first column is a machine number (1-13), the second one is a list of alarm numbers, and the third one has the date & time in which the alarm number was triggered and recorded.
The alarms trigger whenever there's a failure. In many cases a single alarm displays a set of alarms. If this happens, the alrms triggered and recorded have the same date & time. Therefore, I need to know the number of times a group of alarms has been triggered. I can't do this in excel because I have more than 500,000 records.
Is there a way to this without doing it manually?
Thanks for your help.