30 day Line Chart showing totals of 3 fields per day
From: Sheryl (Sheryl_at_discussions.microsoft.com)
Date: 12/14/04
- Next message: Bernard Peek: "Re: query to self table"
- Previous message: seeker53: "query takes forever to run"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 14 Dec 2004 09:39:16 -0800
I have a table that has 3 date fields that are tied to a pkg no. [In]
[Working] [Out].
Each day the packages move thru the completion process the next date field
would be filled in. Each package will also have all 3 fields filled in by
the time the job make its to completion, which is the [Out] field.
I need to produce a line chart showing the total of [In] [Working] [Out]
pkgs there were for each day. Would this be created thru a query or report
and how would I do this?
Category being the daily date for the past 30 day; Value axis being 0 to 200
by tens. The hard part will be keeping the running total of each field to
they match the log showing what is open, being worked on and closed.
- Next message: Bernard Peek: "Re: query to self table"
- Previous message: seeker53: "query takes forever to run"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
