field names

  • Thread starter Thread starter Dennis
  • Start date Start date
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
 
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
 
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
 
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...
 
Back
Top