reporting showing field caption from field list box records

[timmyfish01]

Hi,

I have numerous forms where I can select a field from a field list box
and it is entered as a record in a table.

What I want to be able to do is to report on the fields, but show their
caption rather than the fieldname (which wouldn't make sense to
anyone!).

My reports current control source is a SQL Statement rather than direct
table or query use.

Please advise on what I can do to get the fields caption reported and
not the feild name.

My ulitmate aim is to use the fields referenced in the records to
update the source table where the fields are. One step at a time
though!

Thanks,

Tim

 

[JK]

Timmy,

In your query definition use,

Select [Filed1] As [YourCaption1],[Field2) As [YrCaption2] etc

Regards/JK

 

[timmyfish01]

Thanks for helping JK, although there are over 40 fields and i have
already contemplated using the =IIF function to achieve it.

Is there anyway of coding this for a more compact automated solution?

Thanks

 

[JK]

My pleasure Timmy,

Unfortunately I don't know a simple way :-(

Regards
JK