Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-14-2012, 12:32 PM   #1
digitalshepard
Newly Registered User
 
Join Date: Jul 2011
Posts: 32
Thanks: 4
Thanked 0 Times in 0 Posts
digitalshepard is on a distinguished road
Post Guidance on writing query for chart or pivot chart

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!)
Attached Files
File Type: xls Sample Tables.xls (49.5 KB, 59 views)

digitalshepard is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Controlling pivot chart data categories (query based) munkee Modules & VBA 3 08-25-2010 04:25 AM
pivot chart ? saleemMSMS Reports 2 11-12-2009 03:33 AM
Query to use on Pivot Chart / Report Grafixx01 Queries 1 09-05-2008 04:53 AM
create pivot chart from pivot table?? dhx10000 Tables 0 03-13-2006 04:11 PM
pivot chart ebiscaro General 0 05-26-2003 10:21 AM




All times are GMT -8. The time now is 03:50 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World