Problem writing code of query into a form

[PatT123]

This query works in the query window. If you name it in control source it
works. If you write the code into the control source of a form, it gives a
syntax error in the from clause..... Why? and can someone help me fix it?


SELECT TBLFUNDINGTOPOS.PosNo, TBLFUNDING.Funding, TBLFUNDING.PCA,
TBLPCA.Fund, TBLFUNDING.FedGrant_PH, TBLFUNDING.OthGrant_PH,
TBLFUNDINGTOPOS.Percent, TBLPCA.SubProgram, TBLFUNDINGTOPOS.TotalFTE,
CurrFTE.SumOfPercent AS CurrPurcent, TBLPCA.FundType
FROM (TBLFunds RIGHT JOIN TBLPCA ON TBLFunds.FUND = TBLPCA.Fund) RIGHT JOIN
(TBLFUNDING RIGHT JOIN (TBLFUNDINGTOPOS LEFT JOIN [SELECT
Sum(TBLFundingToPos.Percent) AS SumOfPercent, TBLFundingToPos.DIVFund
FROM TBLFundingToPos
GROUP BY TBLFundingToPos.DIVFund]. AS CurrFTE ON TBLFUNDINGTOPOS.DIVFund =
CurrFTE.DIVFund) ON TBLFUNDING.Funding = TBLFUNDINGTOPOS.Funding) ON
TBLPCA.PCA = TBLFUNDING.PCA;

Thank you

 

[Van T. Dinh]

(see reply in previous thread)

Please allow time for your question to be replied to and don't repost the
same question after only a few hours.

Most potential respondents answer questions on a volunteer basis free of
charnge and can only do so when time allows. Posting the same question
multiple times in same / different newsgroups simply waste everyone's
reading the same question.

Please see http://www.mvps.org/access/netiquette.htm

HTH
Van T. Dinh
MVP (Access)