Board index Office Access

AVG(COUNT(timestamp))...this will not work, what am I doing wrong?

AVG(COUNT(timestamp))...this will not work, what am I doing wrong?

Post by Mitchell_C » Sun, 15 Jul 2007 06:13:47


Please help me. I want to find the average of the number of timestamps that
are in several tables. When i run the following, it will not work because I
can only use avg with a number datatype. (at least, that's what i understand)
I am just learning the syntax rules. the following works as long as i don't
include avg. Please help me.

Select avg( count(timestamp),area), datepart(hh,timestatmp), datepart(wd,
timestamp)
From lotsoftables
where timestamp between 05/01/2007 and 06/20/2007
Group by timestamp,datepart(hh,timestatmp), datepart(wd,timestamp),area

Thanks in advance.
-Misty

--
Message posted via http://www.yqcomputer.com/
 
 
 
Top

1. .NET Assembly works, but not via Workflow...What am I doing wrong?

2. Derived Dialog Does Not Work, am I doing it wrong?

3. Cisco 837 NAT not working, what am I doing wrong?

4. Hit Area still not working--what am i doing wrong

5. Query in VB will not work..What am I doing wrong?

6. KeyEvent consume() not working on JTextField, what am I done wrong?

7. Custom sharepoint search does not work : what am I doing wrong?

8. Key events work in Netscape and IE, but not Firefox - what am I doing wrong

9. KeyEvent consume() not working on JTextField, what am I doing wrong?

10. table_info not working, am I doing something wrong?

11. user.IsApproved = false; is NOT working, what am I doing wrong????

12. Still not working ( What am I doing wrong (subject filtering))

13. C# Retrieve COUNT from SQL Query - What am I doing wrong?

14. query with COUNT (what am I doing wrong?)

All times are UTC
Board index