Change Column Headings in a CrossTab Query

[Stephen Glynn]

I've got a cross tab query that totals some values based on what users
have entered using an option group on a form.

The columns give me a count of the entries for each option group, which
is what I want. However, the headings give the number of each option
-- 1, 2, 3, -- which isn't particularly useful. How can I re-label the
columns so the user knows what option 1 is?

Steve

 

[Duane Hookom]

Change your column headings field to the field with the option description.
If you don't have these values in a table, you can use an expression or
function like:
ColHead: Choose([Your Field],"Title for 1","Title for 2",....)

 

[Stephen Glynn]

Thanks. That did the trick.