Uderc programming article aggregator sites

How to create an Event & schedule a rpt based on results of that Event..

Advertisement
Help,
I need to schedule a report, that will run after an event is done. I only want the rpt to run if the event produces more than 1 record.
I dont know how to create an event? I am assuming I can use a SQL qry as an event. I would like to use:
select count(*) as RegCounts from [reg contact log] 
where [due date] = date() +1 and [response due]=Yes
Erin
Advertisement
The best answer: Help,
I need to schedule a report, that will run after an event is done. I only want the rpt to run if the event produces more than 1 record.
I dont know how to create an event? I am assuming I can use a SQL qry as an event. I would like to use:
select count(*) as RegCounts from [reg contact log] 
where [due date] = date() +1 and [response due]=Yes
Erin