Change the view definition to be
personid >= ?personid1 and personid <= ?personid2
and
year >= ?year1 and year <= ?year2
To retrieve all the records, make personid1 and year1 smaller than the lowest possible values and personid2 and year2 bigger than the largest possible values.
To retrieve for a specific person/year combination, set personid1 the same as personid2 and year1 the same as year2.
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer