Re: Starting Date of Week(Week Number Issue)

From: Ben Arthur (skchbs_at_yahoo.com)
Date: 03/04/04 

Date: Thu, 04 Mar 2004 06:05:57 -0800

select avg(DATEDIFF(n,s.cStart,s.cStop)) avg,DAtename(ww,b.cTime) days
from tablex s INNER JOIN tabley b on group by DAtename(ww,b.cTime) order
by avg desc

this is the query i had....which i formed with great difficulty, looking
for the right function, i havelittle clue as to what you have
suggested....could you please elaborate, i m sure its pretty simple and
i feel silly asking, but really need your help !
thanks
Ben

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Mix/Max/Avg Help based on dynamic ranges
    ... Did you enter Biff's formula as an array? ... The query I gave you is dependent on your breaking out the ranges as Biff ... Where Nums are the values to avg based on the head count range. ... deemed optimal for building device profiles based on locn size and device ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Query SQL not working..
    ... fact that the Avg & StDev are looking at all values including zeros. ... underlying query itself? ... Vanderghast, Access MVP ... aggregate in the WHERE clause, since the aggregation has not occurred ...
    (microsoft.public.access.queries)
  • Re: Slow GROUP BY
    ... As far as the AVG goes, I need to get summary information on the Complete ... "Darren Shaffer" wrote: ... > decreases the chances of your query being optimizable at all. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Average within a record
    ... I just found out that we need the avg to be used in a query, ... I tried making an event for the avg in the code editor but to no avail... ... It will avoid the divide by 0 problem. ... > Dim lngDivisor as Long ...
    (microsoft.public.access.formscoding)
  • Re: Query SQL not working..
    ... I think the extra values are stemming from the underlying query in the fact ... that the Avg & StDev are looking at all values including zeros. ... You cannot refer to an aggregate ...
    (microsoft.public.access.queries)