Query Field Names from Tables

G

Guest

Is there a way to return the field names (not the underlying data) for all
tables in a query? (not looking for properties, just name)

I have a DB designed by anther person with 20+ tables. I am trying to
figure out what table has what fields.
 
G

Guest

nFaux,

Access has a built-in documenter that will do this. Choose Tools, Analyze,
Documenter. Select the Tables Tab and click the Select All button. Click
the Options button, and select Nothing for the indexes, and Names, DataTypes
& Sizes for the fields.

Sprinks
 
G

Guest

nFaux,

Access has a built-in documenter that will do this. Choose Tools, Analyze,
Documenter. Select the Tables Tab and click the Select All button. Click
the Options button, and select Nothing for the indexes, and Names, DataTypes
& Sizes for the fields.

Sprinks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't drag in drop to create a query 0
Form from a query 1
Append query without field names 2
Query to obtain Schema and other info about the DB tables 2
Field by Field Comparison 3
Union Query by choice.. 11
Find duplicate records in two tables. 2
Combine multiple tables into one 8

Top