Hi,
I'm creating a report and everytime I want to see it it creates an extra sheet between pages 1-2, 2-3, 3-4, 4-5, 5-6, 6-7, 7-8, etc.
Is there a way to avoid this extra sheet?
------------
I also have another question. My report is based on a table. It updates upon queries. In the table I have 4 columns that matter: a) Machine number, 2) Alarm number, 3) Alarm time, and 4) Delta time.
Every machine triggers certain alarms according to certain events. A machine can trigger an alarm number at the same time (e.g. 3 alarms can trigger at 11:11:11 AM). But they can also trigger at different times in the same day. The Delta time is the difference between alarm turned off and triggered. I need to sum up the delta time per machine and per alarm.
How can I do this?
Thank you
I'm creating a report and everytime I want to see it it creates an extra sheet between pages 1-2, 2-3, 3-4, 4-5, 5-6, 6-7, 7-8, etc.
Is there a way to avoid this extra sheet?
------------
I also have another question. My report is based on a table. It updates upon queries. In the table I have 4 columns that matter: a) Machine number, 2) Alarm number, 3) Alarm time, and 4) Delta time.
Every machine triggers certain alarms according to certain events. A machine can trigger an alarm number at the same time (e.g. 3 alarms can trigger at 11:11:11 AM). But they can also trigger at different times in the same day. The Delta time is the difference between alarm turned off and triggered. I need to sum up the delta time per machine and per alarm.
How can I do this?
Thank you
