Guidance on writing query for chart or pivot chart

digitalshepard

Registered User.
Local time
Today, 07:36
Joined
Jul 20, 2011
Messages
32
I want to build a query using data from sheet 1 of the attachment for the purpose of building either a chart like in chart 4 of the attachment, or a pivot chart. This chart shows a running sum of items per employee for the most recent 30 days. Ideally I could make a pivot chart to filter data by supervisor and employee.

The approach I have in mind is to build a query similar to what is in sheet 2 of the attachment, possibly using a crosstab. Also, getting the 30 most recent dates is a bit of a challenge as access doesn't support a BOTTOM syntax similar to the TOP syntax.

Before I get too far on this, anyone have guidance on the best way to approach this (or if you already have a query or set of queries that does this, all the better!)
 

Attachments

Users who are viewing this thread

Back
Top Bottom