simplycaren
Programmer
Is there a way to rename entries in a record when they appear on a chart?
Here is an explanation:
I have a table that has percentages based on different locations, and then based on the consolidated totals. Each record has a different location for each period of of the year.
I need these to appear on a chart, but I want the series to be named something other than what's in the record. IE Cincinnati should appear as CVG On Time.
I've tried creating queries for each different city that I want and then for the consolidated totals, and then grouping all of the queries together in another query, but when I do that I get like 80,000 records. I have tried joining different fields and restricting duplicate values, etc. But I just can't seem to make it work.
I have tried to base the chart off of more than one query and that doesn't seem to be working either. I just can't figure it out!
Any help is MUCH appreciated.
Here is an explanation:
I have a table that has percentages based on different locations, and then based on the consolidated totals. Each record has a different location for each period of of the year.
I need these to appear on a chart, but I want the series to be named something other than what's in the record. IE Cincinnati should appear as CVG On Time.
I've tried creating queries for each different city that I want and then for the consolidated totals, and then grouping all of the queries together in another query, but when I do that I get like 80,000 records. I have tried joining different fields and restricting duplicate values, etc. But I just can't seem to make it work.
I have tried to base the chart off of more than one query and that doesn't seem to be working either. I just can't figure it out!
Any help is MUCH appreciated.
