0

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]) " +
3
Contributors
4
Replies
5
Views
7 Years
Discussion Span
Last Post by Geekitygeek
0

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]";
0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.