Hi,
I am using Access 2007. I am trying to set up a timer event with an "If Then" statement that runs the following code:
SELECT Count([Schedule].MAS500number) as CountOfRecords
FROM Schedule
WHERE (((Schedule.Ord erClass) Like "*remake*") AND ((Schedule.Rema keInt) Is Null) AND ((Schedule.Stat us) Is Null Or (Schedule.Statu s)<>"shipped")) ;
and if the "CountOfRecords " is greater than zero it opens a form. I can't figure out how to make it work.
thanks,
Jeff
I am using Access 2007. I am trying to set up a timer event with an "If Then" statement that runs the following code:
SELECT Count([Schedule].MAS500number) as CountOfRecords
FROM Schedule
WHERE (((Schedule.Ord erClass) Like "*remake*") AND ((Schedule.Rema keInt) Is Null) AND ((Schedule.Stat us) Is Null Or (Schedule.Statu s)<>"shipped")) ;
and if the "CountOfRecords " is greater than zero it opens a form. I can't figure out how to make it work.
thanks,
Jeff