field names

D

Dennis

Is there a query I can run in Access that will list the
field names of a table?

Please let me know by email if possible.

Dennis
 
R

Rick

What are you trying to accomplish? You could use the "documenter" to
produce a report of all the fields in a table Tools/Analyze/Documenter.

Rick

Is there a query I can run in Access that will list the
field names of a table?

Please let me know by email if possible.

Dennis
 
D

Dennis Brininger

Rick,

Thanks for you reply. The Documentor lists the field name
but then lists many of the attributes. I'm looking for a
simple listing of just the field names, very similar to a
distinct list of field records. Is there such a query?

Dennis
 
J

John Vinson

Rick,

Thanks for you reply. The Documentor lists the field name
but then lists many of the attributes. I'm looking for a
simple listing of just the field names, very similar to a
distinct list of field records. Is there such a query?
Click to expand...

Set the Options on the documentor; you can choose to list field
properties, fields and indexes, just fields, a whole bunch of options.
The default is to waste tons of paper...
 
Top