select * where fieldname between lowvalue and highvalue. If all records are wanted make lowvalue very small and highvalue very large.

>Could somebody give me a hint about how to build a query statement for a parameterized view to retrieve All .or. only a subset?
>
>A central office should be able to view all the information from a cursor while the rest of the offices should only be able to retrieve their own information.
>
>Thanks in advance for any hints.
>
>
>Oscar Corte