Display field description in query (1 Viewer)

[mattkorguk]

Hi all,
Is the above possible?
Basically, some clever soul has used coded fieldnames but then added a description telling you what the field contains, and I need to return this description.
Can it be done?
Cheers
Matt

 

[EternalMyrtle]

I am not sure what type of output you are expecting.

You can see a report showing the details of your query including all of the properties by going to

Database Tools > Database Documenter.

Choose the queries tab and follow the instructions.

This is report, however, and not usable data like a query.

 

[EternalMyrtle]

Also, you could probably extract the description data using VBA...

 

[CJ_London]

In table design, copy the description information to the Caption for each field.

 

[EternalMyrtle]

I did not know that trick!

 

[CJ_London]

just found this which may help (not tested by me)

http://stackoverflow.com/questions/13073565/use-table-field-description-on-form

But I agree with Eternal, I don't think you can use this in a query per se, but you can build the query in VBA