how do I create a Query that returns the list of field names from a Table?

A

Alex

how do I create a Query that returns the list of field names from a Table

Just as a quick example, my table tblCust has three fields, custID, custFName, custLNam

I want a query that return the following

FieldNames (or whatever header
custI
custFNam
custLNam

Thanks for your hel

Ale
 
V

Van T. Dinh

I don't know of any way doing this using a Query but you certainly can use
VBA code to list the Field names of the required Table (TableDef in DAO).
 
Top