Help with Variable

[pkelly]

We have a large TV in our Sales Office which runs a single report with 7 sheets…

The sheets rotate by utilising the show sheet conditional option and a variable (varReportView) e.g. varReportView='1'

The variable is set using the following which is basically a 2 minute loop….

=IF(Odd(Minute(now())) = 0 AND Second(now()) >= 0 AND Second(now())= 20 AND Second(now())= 40 AND Second(now())0 AND Second(now()) >= 0 AND Second(now())0 AND Second(now()) >= 15 AND Second(now())0 AND Second(now()) >= 30 AND Second(now())0 AND Second(now()) >= 46 AND Second(now())

We want to add more sheets to the report and need to now look at increasing this loop to three minutes…

Any suggestions on how I could achieve this?

[swuehl]

I think you got a copy&paste issue here, your expression is not syntactically correct.

I also don't understand why you use  Second(now()) = 20 and Second(now()) = 40, since this is never true.

[pkelly]

Thanks swuehl - yes something has gone wrong with copy and paste - am having issues posting to the forum from my browser - will upload a sample application...

[pkelly]

Please find attached example application....

[swuehl · Accepted solution]

You can use Mod() function instead odd() / even().

[pkelly]

Thank you...spot on...