How do I use the value of a field as a heading for another field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use the resluting value from a field in a query as the
heading/caption of another field in the query. Does anyone know if this can
be done and if so how?
 
I want to use the resluting value from a field in a query as the
heading/caption of another field in the query. Does anyone know if this can
be done and if so how?
Click to expand...

I'm not sure I understand. Could you give an example of the data in
your table, and how you want the resulting query to appear? Note that
Queries aren't designed as data presentation tools - use a Form or
Report instead (in which case you may be able to have textboxes bound
to the two tables).

John W. Vinson[MVP]
 
I have two tables. I want the contents of one table field to be used as the
heading of a field in the other table.
Thanks, macca
 
macca said:
I have two tables. I want the contents of one table field to be used as the
heading of a field in the other table.
Thanks, macca
Click to expand...

macca,

The only thing I can think of is a Cross Tab query (Google: MS Access
Cross Tab Query).


Sincerely,

Chris O.
 
Back
Top