D
Dustin
Hello all
I have created a report that uses 2 tables and one querie to make a pie
chart for amount of time related to events, that are in turn related to a
specific piece of equipment, which are related to a specific facility. This
all works, and I get a wonderful pie chart for each record. My problem is
that I can't figure out a way to limit the dates that the pie chart is based
on. I tried use a date entry in the time querie but I have to enter it for
each record that comes up and my client will not accept that. Also I would
like to use the dates I enter to calcualte a total time.
I have created a report that uses 2 tables and one querie to make a pie
chart for amount of time related to events, that are in turn related to a
specific piece of equipment, which are related to a specific facility. This
all works, and I get a wonderful pie chart for each record. My problem is
that I can't figure out a way to limit the dates that the pie chart is based
on. I tried use a date entry in the time querie but I have to enter it for
each record that comes up and my client will not accept that. Also I would
like to use the dates I enter to calcualte a total time.