New modern style charts transformed row source problem

Copper Contributor

Hi,

 

Have a Table1 (see an attachment) and a crosstab query on its base. Creating a form with a new style chart (I use Access 2019) with this very query as recordsource. No problem, everything works fine.

 

Then I try to assign to the chart recordsource the same sql syntax as I have in my crosstab query but via VBA. And at this moment an error occurs with explanation that I have some mistake in FROM clause. But how can it be if I use the same syntax which I have in the query which works ok? As I understand the problem happens when Recordsource is being changed by Access in Transformed Recordsource.

 

Please help! Thanks!

1 Reply