By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,486 Members | 1,784 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,486 IT Pros & Developers. It's quick & easy.

Field captions in Queries

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.