Query with join statements to ODBC linked tables get runtime err 3075 1

[smsmail]

Hello,

I have a query that when executed in the access form gets run-time error 3075. But the same query works on the back end SQL Server database when tested. Please see sql statement: What am I missing?


select clientname, mailschedule.jobnumber, mailername,
press, mailertype, StatusDescription, jobstagedescription,
quantity, dropcount, projmaildate1, actualmaildate1,
projmaildate2, actualmaildate2, projmaildate3, actualmaildate3,
projmaildate4,
actualmaildate4, projmaildate5, actualmaildate5, projmaildate6,
actualmaildate6, postagerate, postage, postoffice,
Insert1 , Insert2, Insert3
from MailSchedule
inner join Client on (mailschedule.ClientID = client.clientid)
left outer join Service on (mailschedule.ServiceID = Service.serviceid)
inner join JobStatus on (mailschedule.JobStatus = jobstatus.StatusID)
inner join JobStage on (mailschedule.JobStage = jobstage.stageid)

Thanks in advance for your help!

 

[PHV]

What about this FROM clause ?

FROM (((MailSchedule
INNER JOIN Client ON mailschedule.ClientID =  client.clientid) 
LEFT JOIN Service ON mailschedule.ServiceID = Service.serviceid) 
INNER JOIN JobStatus ON mailschedule.JobStatus = jobstatus.StatusID)
INNER JOIN JobStage ON mailschedule.JobStage = jobstage.stageid

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[smsmail]

It worked! Thanks so much PHV! You are the "BOMB"...as we say in my neck of the woods.