Joe,

You'll have to check here for replies, this place would be pretty useless if the replies just got emailed....

create sql view TheViewName as ;
   select ...

>How do I store a sql statement as a view so other forms can access it?
>please email to jhendren@americanabf.com thank you very much