Thanks Daniel that is a good idea.

Jim

>>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.
>>
>
>You can't build a parameterized view like you can in VFP, but you can query it just like any other table. Build the view without the where clause, and supply that when you need it.