Darn notebooks. I hit the wrong button. anyway i would like to test in the WHERE statement if the year in track.schoolyear is = to the value in schoolyear.nschoolyear. So this year it would be equivalent to
WHERE track.schoolyear = 2003.
So to summarize
I would like to be able to change the value in the WHERE statement for the schoolyear.

Thanks
Jim

>>Hello Group,
>>
>>Can i build a view that uses the value stored in a table called school year?
>>
>>Thanks
>>Jim
>
>I'm afraid we'll need a little more information than that. Is there a particular problem that you are encountering when trying to build the view?