Member Avatar for 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]) " +
  • 3 Contributors
  • 4 Replies
  • 120 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Geekitygeek
Member Avatar for Momerath

What is the extra + on the end doing?

Member Avatar for 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]";
Member Avatar for NH1

please someone help

Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.