missing operator.? Join statement

[NH1]

i get this error

Syntax error (missing operator) in query expression

"FROM (Employee LEFT JOIN DaySchedule ON Employee.[Employee Number] = DaySchedule.[Employee Number] " +
"RIGHT JOIN Rules ON Employee.[Default Shift Code] = Rules.[Rule Name]) " +

[Momerath]

What is the extra + on the end doing?

[NH1]

What is the extra + on the end doing?

Becuase i just wanted help with the join statement, but the rest is right here.

"WHERE Rules.[Rule Name] = '" + Del + "' " + 
"GROUP BY Employee.[Employee Number], Employee.[Last Name], DaySchedule![Shift Code Monday], " +
"DaySchedule.[Shift Code Tuesday], DaySchedule.[Shift Code Wednesday], DaySchedule.[Shift Code Thursday], " +
"DaySchedule.[Shift Code Friday], DaySchedule.[Shift Code Saturday], DaySchedule.[Week Number]";

[NH1]

please someone help

[Geekitygeek]

Please mark this as solved so we can keep all the answers on your other thread.
Please try to avoid posting duplicate threads as it can result in confusion both for solvers and for anyone who reads the thread in the future looking for help.