hwo to use PIVOT inMS ACCessData Base.

Question

sql query as follows;

select *  FROM Tb_SCh_TIme_Table P PIVOT (MAX(Faculty_Code) FOR Session IN ([1],[2],[3] ,[4])) AS PVT
order by course;


when i run results executed in sql server data base working fine.


The same query execute in MS Access Data Base show the error as follows;

Syntax error in FROM Clause.

how can i execute the above query in MS Access Data Base.

how can  i do.I want the answer,pleae reply. help me.