How to get a list of table column names using a single query in Access?

[Raymond]

Hi folks,

I need a single query to get a list of column names for a given table.
I know how to do it in SQL by using some system table, however, I have
no idea how to do it in Access?

Thanks.

Raymond

 

[Duane Hookom]

I don't think anyone else can do this in Access with a single query.