Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I graph multiple date fields?

Status
Not open for further replies.

zeeeeek

Technical User
Apr 12, 2002
3
US
I have a table with to important fields: ReceivedDate and ClosedDate and I want to generate a chart which shows the number of items received and the number of items closed per week. If I set the chart to show the counts of ReceivedDate and ClosedDate on change of ReceivedDate then I get an innacurate count, as the count of closedDate for that group is actually the count of items closed in that week which were also opened in that week.
So my question is how can I get a chart which shows accurate counts of each field per week?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top