Hello. I have to graph two running sums in a report. I have these running sums calculated in a query. Now when i go to add the fields to a graph it only alows "CountOfData". This is not what i need. This only tells me how many data entries there are for each date. I need to graph the actual information.
It says i cant change from CountOfData to ,say for example, MaxOfData because it is a text data. Anyone know how i can get access to recognize the data as a number?
It says i cant change from CountOfData to ,say for example, MaxOfData because it is a text data. Anyone know how i can get access to recognize the data as a number?