kindly please check this expression
kindly please check whats the problem with this SQL expression..
sYear = request("year")
sSQL = "SELECT Sum(TopIpsPerDay.Total) AS Ips, Sum(TopPageViewsPerDay.Total) AS Views, Format([TopIpsPerDay].[Date],'m') AS MonthNumber FROM TopIpsPerDay INNER JOIN TopPageViewsPerDay ON TopIpsPerDay.Date = TopPageViewsPerDay.Date GROUP BY Format([TopIpsPerDay].[Date],'m'), Format([topIpsPerDay].[Date],'yyyy') HAVING (((Format([topIpsPerDay].[Date],'yyyy'))="&sYear&"))"
do while not rs.eof
im getting this error:
Microsoft JET Database Engine error '80040e14'
Extra ) in query expression '(((Format([topIpsPerDay].[Date],'yyyy'))=))'.
i've been taking this for a day... please help...thanks...
Are you sure that you're passing it the Year? It would appear that your sYear variable is blank.
I would Try "HAVING Year([topIpsPerDay].[Date]) =" & sYear & "))"
Let me know if that helps..
If you download MySQLcc you can paste the query into it directly and it should report your error.
Obviously you would have to replace your variables with values.
Originally Posted by candelbc
i got same error.. the Extra (...etc...
Instead of executing your SQL code, try doing a
It sort of appears from the error above that the Variable contains no data or is Null.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)