Richard,

I have owned this seminar for quite a while now and am using it to develop SQL to put into existing forms and reports to replace formal queries as the data source.  In one instance I have a crosstabe query that is the data source for one of my reports.  The query works just fine for the report but when I copy the SQL and place it into the report data source I get an error: "Cannot use the crosstab of a non-fixed column as a subquery".  The report uses only one query as its datasource and that query is not dependent upon any other query.  If I return to using the query itself as the datasource, everything returns to normal and the report runs fine.  Any ideas?

---

Reply from Alex Hedley:

So you aren't setting the SQL in vba you are copy and pasting it into the Record Source of the object? I'm not sure why this would be better that using a Query Object.