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?

Have you actually tried creating a query in Access to test this? Then look at the SQL to view the syntax.

David

Have you actually tried creating a query in Access to test this?
yes

Then look at the SQL to view the syntax.

i'm not sure i get what you mean
i entered the query manually in access

After you create the query in the QBE frame, you can select to view the SQL code. That will show you the "written" code.

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

Try copy and pasting the "manual SQL" into the QBE and see if it works.