Access 2003 SQL Syntax error -


i new access 2003 , been stuck on query have wrote while now. tables , column names, operators , brackets believe correct getting syntax error after inserted following join operation

from (tdailyentries inner join tledgers on tledgers.action = tdailyentries.actionno) inner join (tprojects  

below full code

select distinct tprojects.cc_io projectno, year([datefrom]) & " accrual " & monthname(month([datefrom])) & " - "+[companyname] & " ( "+([lastname]) & ")" [line/item/text], tusers.lastname last_name,  tdailyentries.userid userid,  contractordailyrate dailyrate,  contractordailyhours hours,  round(contractordailyrate / contractordailyhours, 2) hourlyrate, round(sum(tdailyentries.calculateddailyhours), 2) monthlyhours,  round((hourlyrate * monthlyhours), 2) charge,  round(charge+round((charge*0.2),2),2) accruals, tprojects.project project (tdailyentries inner join tledgers on tledgers.action = tdailyentries.actionno) inner join (tprojects  right join (textcontractor  right join (ttitle  right join ((location  right join (tdepartments  right join tusers  on tprojecttype.projecttypeid = tprojects.projecttypeid) on tdepartments.deptid = tusers.deptid)  on tlocation.locationid = tusers.locationid)  right join (((tdailyentries  left join tdepartments tdepartments_1  on tdailyentries.deptcharged = tdepartments_1.deptshortname)  left join tactions on tdailyentries.actionno = tactions.actionid)  left join tlookups  on tdailyentries.zone = tlookups.lookupid)  on tusers.userid = tdailyentries.userid)  left join textmain  on tusers.userid = textmain.userid)  on ttitle.titleid = tusers.titleid)  on textcontractor.companyid = textmain.contractorcompany)  on tprojects.projectid = tdailyentries.projectno ttitle.titleid = 37  , month([datefrom]) = monthnum  , day([datefrom]) <21 group tprojects.cc_io, year([datefrom]) & " accrual " & monthname(month([datefrom])) & " - "+[companyname] & " ( "+([lastname]) & ")", tusers.lastname, tdailyentries.userid, textmain.contractordailyrate,  month([datefrom]), textmain.contractordailyhours, tprojects.project; 

any great.


Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -