S
Sheryl
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.
[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.