run time error 3067 in Access with SQL query

Question

All Works fine now! Thank you all for your help

I have been looking at the same line of code for the last two hours and don't understand why I continue to get the same Run Time Error 3067 message (input for the query must contain at least one table/query). This query is suppose to take three tables, linked with relationships and past 4 columns to a 4th table. The code below I copied directly from a query built in Access which worked..

 DoCmd.SetWarnings False
 st_sql = "INSERT INTO tblContactsProjectTrk01 ([Participant], [Sub_Project], [Role_type], [Completion_Percentage])" & _
 "SELECT [tblProjManagementPhaseParticipants].[Participant], [tblProjectMasterList].[Sub project], [tblProjManagementPhaseParticipants].[Role_type], Avg([tblMasterListOfEvents].[Completion percentage]) AS MediaDiCompletion percentage" & _
 "FROM[tblMasterListOfEvents] INNER JOIN ([tblProjManagementPhaseParticipants] INNER JOIN [tblProjectMasterList] ON [tblProjManagementPhaseParticipants].[ID_Project] = [tblProjectMasterList].[ID Project]) ON ([tblProjectMasterList].[ID Project] = [tblMasterListOfEvents].[ID Project]) AND ([tblMasterListOfEvents].[ID Event] = [tblProjManagementPhaseParticipants].[ID_Event])" & _
 "GROUP BY([tblProjManagementPhaseParticipants].[Participant], [tblProjectMasterList].[Sub project], [tblProjManagementPhaseParticipants].[Role_type])" & _
 "ORDER BY[tblProjManagementPhaseParticipants].[Participant]"

Application.DoCmd.RunSQL (st_sql)

Niall · Accepted Answer · 2014-01-18 17:04:58Z

2

There is no space before the FROM, so it is actually percentageFROM. I think it should be

...Avg([tblMasterListOfEvents].[Completion percentage]) AS [MediaDiCompletion percentage] " & _
"FROM[tblMasterListOfEvents]...

answered Jan 18, 2014 at 17:04

Niall

1,6214 gold badges24 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Marchese Il Chihuahua Over a year ago

Fantastic! Thank you ... Now however the new message is run time error 3075... missing operator...??

Niall Over a year ago

I'd suggest going back to Access and creating your query again using the visual designer then switching to SQL view and copying that into your VBA code. You just need to make sure you include all the spaces

Marchese Il Chihuahua Over a year ago

Crazy Horse, i re-did everything and copied and pasted the SQL code from the Access query which worked but i am still getting the 3075 message telling me i am missing an operator

keith b · Accepted Answer · 2015-07-10 15:08:51Z

1

You have the same problem with your line wrapping before your GROUP BY and ORDER BY statements. You need spaces between the previous line and those two statements.

answered Jul 10, 2015 at 15:08

keith b

194 bronze badges

Collectives™ on Stack Overflow

run time error 3067 in Access with SQL query

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related