Caption property in Query

[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.

 

[Guest]

Post an example of your present data and then what you would like to see in
results.

 

[Bruce Acciavatti]

Field 1 contains the value "ABC", Field 2 contains the value 123. I want to
assign "ABC" to the caption for Field 2, so that the heading for Field 2 is
"ABC" and it contains the value 123. That's it.

 

[Guest]

I do not think it can be done as field1 will have many different values but
you can have only one caption for field2.

You can bring your criteria for field1 as an output by copying the prompt
and pasting it in the field row of the query grid.