>Ian ;
>If the user is using the query wizard is there a way to access the select statement from and exe not within FoxPro to get the exact statement and then apply some of my one code to it to create the dbf from the query.
>
>PS.
>Thanks to all for the responses. I'm going to try all of them to see what best suits the client.
>
>Shawn

Why not just make it easy for the user to query the data. Very few users understand the query wizard, let alone SQL. Look at something like QBF Builder from ClassyComponents.