You have wrong table name, 'thistable' instead of 'csulog6'.

>In my VB asp page I have this line
>"SELECT distinct office FROM thistable where nsn like" + "'51%' order by office"
>
>and I get this error
>
>A field or property with the name 'nsn' was not found on the selected data source.
>However "SELECT distinct office,nsn FROM csulog6 where nsn like" + "'51%' order by office" does work
>
>PS, I am using VFPOLEDB to access a microsoft visual Foxpro table