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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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).
 

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

return primary key for record after append query 3
Query to return field names from table 1
function that returns the field name 3
dynamic calculated field in query 3
Parameter queries that allow users to choose items from a list 3
query to trim name field? 5
Create IN criteria from another table 1
Query and List Box 1

Back
Top