casperthedog
Instructor
I created a crosstab query in MS Access which genrated the following SQL:
TRANSFORM First(tblBookText.text) AS FirstOftext
SELECT tblBookText.page, tblBookText.line
FROM tblBookText
GROUP BY tblBookText.page, tblBookText.line
PIVOT tblTEXT.word;
(My table has the following fields: ISBN, page, line, word, text. I am trying to store the text of a short book in a database with each word separately)
The crosstab query displays the text nicely on a form as it was displayed originally in the book
However I can't seem to use the same SQL code in the Visual Studio query builder. It doesn't seem to like the TRANSFORM statement.
Is there a different way to create such a query?
TRANSFORM First(tblBookText.text) AS FirstOftext
SELECT tblBookText.page, tblBookText.line
FROM tblBookText
GROUP BY tblBookText.page, tblBookText.line
PIVOT tblTEXT.word;
(My table has the following fields: ISBN, page, line, word, text. I am trying to store the text of a short book in a database with each word separately)
The crosstab query displays the text nicely on a form as it was displayed originally in the book
However I can't seem to use the same SQL code in the Visual Studio query builder. It doesn't seem to like the TRANSFORM statement.
Is there a different way to create such a query?