Search results

  1. V

    weekly averages

    i didn't enter the query this way: I entered the SQL statement manually. why doesn't it work?
  2. V

    weekly averages

    yes i'm not sure i get what you mean i entered the query manually in access
  3. V

    weekly averages

    Hi guys, I need to return a dataset to a vb.net program with weekly averages. So far I have: SELECT AVG(a) as A, AVG(b) as B FROM results WHERE fk=0 GROUP BY DATEPART(ww,myDateTime) I was hoping somebody could shed some light on why this doesn't work?
Back
Top Bottom