Field captions in Queries

[Bruce Acciavatti]

Is there any way, outside of using VB, to assign a caption to a field in a
query to the value of another field. I've tried using the properties window,
but haven't been successful.

For example, I have the results of a crosstab query, with fields that
contain values and fields that contain headings for those values, and I want
to assign in the new query that reads the first query's results the field
that contains the caption to the field containing it's corresponding value.

[MacDermott]

It might help you to use the ColumnHeaders property of the crosstab query to
make those headers uniform.

"Bruce Acciavatti" <vi*@gmavt.net> wrote in message
news:11*************@corp.supernews.com...

Is there any way, outside of using VB, to assign a caption to a field in a
query to the value of another field. I've tried using the properties window, but haven't been successful.

For example, I have the results of a crosstab query, with fields that
contain values and fields that contain headings for those values, and I want to assign in the new query that reads the first query's results the field
that contains the caption to the field containing it's corresponding value.