>Hi steve,
>
>I'm not that fond of using the SQL designer. All too often i'm stuck in some error, or come to the conclusion it is not as flexible as SQL in VFP.
>
>One question though. Is it possible to execute the query in VFP (I don't know where the tables come from) or in any other environment and send the result as one table into for example a FOX 2.x table ?
>
>
>Walter,

Walter - unfortunately, no access to the data engine - which isn't VFP anyway. This is one of those 'afterthoughts' where a project has marched on and now some special reports are needed - so the tools that Crystal provides are all that are available right now.

As I first looked at this - the reports were of the type that I'd normally hybrid - prep data in VFP and then send to reportgen for pretty printing.

We'll keep banging on the SQL - thanks.