Change Column Headings in Xtab Query

Indigo

Registered User.
Local time
Today, 12:04
Joined
Nov 12, 2008
Messages
241
Hello all! This may not be possible, but I thought I would ask. I have inherited an Access 2003 database and have been asked to help improve the functionality of said database. Specifically, I have been asked to create some charts for improved reporting. I used the wizard to create a crosstab query to support the chart(s):

Code:
PARAMETERS [Forms]![Switchboard]![ActualDate] DateTime;
TRANSFORM Sum(qryPMCompletion.CountOfWOs) AS SumOfCountOfWOs
SELECT qryPMCompletion.PA_Priority
FROM qryPMCompletion
GROUP BY qryPMCompletion.PA_Priority
PIVOT qryPMCompletion.wo_Completed
WITH OWNERACCESS OPTION;
Now what has happened is that the wo_Completed is a Yes/No field so my column headings and therefore my legend comes up as "-1" and "0" instead of "Closed" and "Open".

Is there anyway to change the name of the column headings or shall I just create my own legend? Thanks!
 
Make that field a calculated field. In design view, change wo_Completed to this:

Iif(wo_Completed, "Closed", "Open")
 

Users who are viewing this thread

Back
Top Bottom