Caption property in Query

ExpandCollapse

Guest

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.

ExpandCollapse

Guest

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

"Bruce Acciavatti" wrote:
> 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.
>
>
>

ExpandCollapse

Guest

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.

"KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message
news:3B5A082D-1E2C-4B70-9F61-2A1025DB7909@microsoft.com...
> Post an example of your present data and then what you would like to see
> in
> results.
>
> "Bruce Acciavatti" wrote:
>
>> 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.
>>
>>
>>

ExpandCollapse

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.

"Bruce Acciavatti" wrote:
> 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.
>
> "KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message
> news:3B5A082D-1E2C-4B70-9F61-2A1025DB7909@microsoft.com...
> > Post an example of your present data and then what you would like to see
> > in
> > results.
> >
> > "Bruce Acciavatti" wrote:
> >
> >> 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.
> >>
> >>
> >>
>
>
>

Share This Page

If asked to provide a Cliff Notes version of the Sikh way of life -- the pitch to be no longer than a short “elevator ride,” I think most Sikhs would opt for the popular triad: Naam japna, Kirt karni, Vand chhakna.

About Us

Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Like us on Facebook

Support SPN

The management works very hard to make sure the community is running the best software, best designs, and all the other bells and whistles. We'd really appreciate your support!