JOIN expression not supported

[seageath]

Hi all,

I have the following error related to my query "JOIN expression not supported", I have run it on Access 2010 it's working just fine, but when I want to call it from Excel to copy the recordset I encountered the error. What might cause the problem? Here are the query

SELECT tblArea.Month, tblArea.Year, tblAreaPeriod.*FROM (tblAreaPeriod INNER JOIN tblArea ON tblAreaPeriod.AreaID = tblArea.AreaID) INNER JOIN tblPeriod ON tblAreaPeriod.PeriodID = tblPeriod.PeriodIDWHERE (tblArea.AreaName)= "America")

Thank you.



-sea-

[alansidman]

Why not just export the query result in Access to Excel?

[seageath]

Why not just export the query result in Access to Excel?

Yes, I plan to do that after running the query from excel.

Sorry just found out that when I copied the query to excel VBA I missed some spaces, that was caused the problem.

Problem solved for now

Thanks Alan for the reply