>>>>>As given above the sql returns the correct information. But when I put "Create Sql View ViewName As" at the beginning of the statement, it returns no rows. ?????


>Ok. I've duplicated the fields and have run both the select and then the >query with exactly the and received the exact same results both times. But the >creation of the view. Being a one time event my code looks like this.

dFyr='1998' && forgot to add this.
>OPEN DATABASE TRAVEL
>USE LVTEMP && The name the view.
>BROWSE