Can anyone PLEASE help with the correct syntax for this sql statement?
It works fine in Access and gives the desired results but i cannot make it work with mySQL. The table is fine, i have checked field names etc...but it will not run
SELECT Count(PageUrl)AS PageCount, PageUrl as URL FROM tbltracker WHERE HitDateTime >= #01/01/2001# AND HitDateTime <= #06/01/2001# AND id='biz' GROUP BY PageUrl ORDER BY Count(PageUrl) DESC
MySQL said: You have an error in your SQL syntax near '' at line 1
Many Thanks
Mark Baxter UK
It works fine in Access and gives the desired results but i cannot make it work with mySQL. The table is fine, i have checked field names etc...but it will not run
SELECT Count(PageUrl)AS PageCount, PageUrl as URL FROM tbltracker WHERE HitDateTime >= #01/01/2001# AND HitDateTime <= #06/01/2001# AND id='biz' GROUP BY PageUrl ORDER BY Count(PageUrl) DESC
MySQL said: You have an error in your SQL syntax near '' at line 1
Many Thanks
Mark Baxter UK