adding a field name to a query

[Jon123]

I hope I can ask this question so that it makes sense.

I have a totals query that I'm using to make a Chart. The query works fine but I want to change the look abit. What I'm doing is quering a table looking for the total number of times that there is a check box in a field called PDC RTA and totaling the Hrs as well. The data comes back looking looking like this.
PDC RTA-----Count-----Total Hrs
-1 ---------- 6 -------- 53
0 -----------25 -------- 78

My problem is that when I chart this the -1 and 0 show up at the bottom of the bars on the chart. I would like to rename these to fields on the qry qrid then I can chart the new field names so that it will make sense to the user.

Make sense

Jon

 

[FoFa]

IIF([PDC_TA],"True","False")
Since it is a check box, it is true or false and IIF can tell, so where I have the "True" or the "False" in the above, just substitue your values instead.

 

[Jon123]

AWESOME

Thank you


jon