>I have a local view that uses an integer and a year to retreive training records. The integer is the personid and the year is for the training year. Is there a way I can send a parameter that will retrieve all the training records?
>The SQL where is as follows:
>WHERE personid = ?vwpersonid;
>AND yesr(class_date) = ?vwyear
add a logical allrecords variable
WHERE personid = ?vwpersonid AND yesr(class_date) = ?vwyear OR 1=?IIF(m.allrecords,1,0)