query

  • Thread starter Thread starter ps
  • Start date Start date
P

ps

Is it possible to collect the actual field name(s) of one
query/table as the output of another, and not the
contents of the fields eg


table1: fields A,B,C

Query output select something1,something2,something3 from
table 1;

output Something1 Something2 Something3
'A' 'B' 'C'
 
It would be very unusual to need the contents of the fieldname to be
returned as a value in a query... unless the fieldnames had embedded data.

Can you provide a bit more information about your fields, fieldnames, and
data?
 
The reason for my most unusualy request is that the cross
tab query will generate different column headings and
different number of column each time it is run.

I wish to generate a report that displays those coulmn
headings as they vary.

hence might need up to say 10 fields across the page each
returning the name of the field. hope this isnt too
confusing.
 
Back
Top