aguest Posted October 5, 2015 Share Posted October 5, 2015 Hi, I can't get the script below to return anything other than ? once I've joined the tables. Can anyone see why? TIA ExecuteSQL ( " SELECT b.ClearLearningRating, count(*) FROM LessonObservations a INNER JOIN Observations b on a.[pk] = b.[fk_TeacherEvaluations] WHERE a.obsdate >=? AND a.obsdate <= ? AND a.YearGroup = ? GROUP BY b.ClearLearningRating " ; "|"; "¶" ; $Repstartdate;$Rependdate;$RepYearGrp ) Link to comment Share on other sites More sharing options...
Wim Decorte Posted October 5, 2015 Share Posted October 5, 2015 "?" always means a syntax error. Do your fields really have square brackets in their names? Link to comment Share on other sites More sharing options...
aguest Posted October 5, 2015 Author Share Posted October 5, 2015 No but even without the square brackets I'm getting the ?. I can't figure out where the syntax error is. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3254 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now