Table field name and/or description in a query

[mpdsal]

Is it possible to view both the table field name and a description in a query? This would be the description contained in the table for each field it contains. I would prefer to see description instead of field name in the output on some queries I run. How would I do this if it is possible?

I am using Access 2007.

Thanks

Mark

 

[gemma-the-husky]

no - the query design window gives you a graphical way of writing SQL commands

view a query as SQL to see what you "really" were doing - which is processing tables and fields

 

[mpdsal]

I'm not sure I follow. Let's say I wrote a query using SQL instead of the query design feature. Is there code I can include that would say: give me all records for Field A in Table A but instead of the Field A name appearing as the column name in the output it would be the description of field A (which is populated when you create a table) which is lets say as an example "Employee address". This appears in the output as opposed to Field A. Hope this is clearer.

Thanks