Prev: crosstab - multiple values required
Next: Get run time from date time stamps
From: Access Admirer Access on 15 Apr 2010 12:31
I have a linked query that shows projected quantities on the first day of
each month for that month. It also does not display any other dates except
the first date such as
ReqDate Qty
1/1/2010 3250
2/1/2010 4500
3/1/2010 3875

I need to break these quantities into weekly buckets and then develop a
query that provides a rolling 13 week average query. I can create the query
to perform the 13 week rolling average, but I can't seem to create a query to
break the quantities into the weekly bucks from the monthly. Any Ideas?
From: Jeff Boyce on 15 Apr 2010 13:00
?You're trying to compute a 13-week rolling average of projected amounts? I
thought rolling averages were usually reserved for actual amounts, not
projections...

How do you want to handle months that don't have an exact whole number of
weeks (i.e., every month except February, except in leap years)?!

You'll need to provide a bit more definition of how you want to handle the
partial week issue before we have enough information to offer suggestions on
"how"...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Access Admirer" <Access Admirer(a)discussions.microsoft.com> wrote in message
news:A371DE61-E959-41CA-BDE3-D0060E55A3ED(a)microsoft.com...
>I have a linked query that shows projected quantities on the first day of
> each month for that month. It also does not display any other dates
> except
> the first date such as
> ReqDate Qty
> 1/1/2010 3250
> 2/1/2010 4500
> 3/1/2010 3875
>
> I need to break these quantities into weekly buckets and then develop a
> query that provides a rolling 13 week average query. I can create the
> query
> to perform the 13 week rolling average, but I can't seem to create a query
> to
> break the quantities into the weekly bucks from the monthly. Any Ideas?


 | 
Pages: 1
Prev: crosstab - multiple values required
Next: Get run time from date time stamps