yep. Heck, it even works in Access :)
>Does the question mark only work on 5 and above?
>
>Thanks
>
>
>>Views are generally used to get a set of data, for example, all customers in New York. The SQL would include something like WHERE State = "NY". If you put this "NY" constant into the view designer, then you would always get New York customers. You'd never get California customers, so you use a view parameter and your SQL looks like WHERE State = ?vpState. The view parameter is simply a variable. When the query runs, if vpState does not exist, a window will pop up asking for a value. If vpState exists, then it will be used.
Mark McCasland
Midlothian, TX USA