Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Caption property in Query

Discussion in 'Information Technology' started by Bruce Acciavatti, Nov 5, 2005.

  1. Bruce Acciavatti

    Bruce Acciavatti
    Expand Collapse
    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.
     
  2. Loading...

    Similar Threads Forum Date
    Tenth Sikhtoons Caption Contest Sikh Toons Jul 5, 2009
    Ninth Sikhtoons Caption Contest is On! Sikh Toons Jun 2, 2009
    Eight Sikhtoons Caption Contest Winner Sikh Toons May 19, 2009
    8th Sikhtoons Caption Contest Sikh Toons May 8, 2009
    [SPN] Seventh Sikhtoons Caption Contest Announcements Apr 3, 2009

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    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.
    >
    >
    >
     
  4. Bruce Acciavatti

    Bruce Acciavatti
    Expand Collapse
    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.
    >>
    >>
    >>
     
  5. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    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