syntax error in Transform statement

[jzacharias]

I can't find any posts regarding a syntax error in Transform statement. I believe it is the chart that is causing the problem. I can view the chart in report view, but if I change is to print preview, I receive the error. Anyone have any experience with this problem?

 

[jzacharias]

This is what is in the row source

TRANSFORM Count(*) AS [Count] SELECT [Shift] FROM [Yearly Citation Totals by Shift and Rotation]