How to include field names as first row of selct query?

From: "TD" <dlee@xxxxxxxxxxx>
Date: 21 Nov 2005 20:59:49 -0800

I need to return the field (or column) names as the first row in a
select query. Any way to do this without resorting to vba?

Thanks,
TD

.

Follow-Ups:
- Re: How to include field names as first row of selct query?
  - From: Steve Jorgensen

Prev by Date: Re: in front end application and back end tables
Next by Date: Re: Best way to tell if X is between two values? A97
Previous by thread: Reset Increment number on new month
Next by thread: Re: How to include field names as first row of selct query?
Index(es):
- Date
- Thread

Relevant Pages

Re: How to include field names as first row of selct query?
... >I need to return the field names as the first row in a ... >select query. ... Any way to do this without resorting to vba? ...
(comp.databases.ms-access)
list of numbers stored as text in a table cell as the criteria for a query?
... clause of a query. ... I think there should be a quick way of doing this without resorting to ... VBA, but I can't think what it is. ...
(microsoft.public.access.queries)
Re: Merging content from access
... My hunch at the moment is that this is a problem in my access query. ... I agree with you that Word VBA is a more elegent solution. ... The other field-based technique requires you to have a "parent" table as ... the mail merge data source and a child table inserted using a DATABASE ...
(microsoft.public.word.docmanagement)
Re: Merging content from access
... that could well be the case - I guess you'd see if you ran the same query in Access. ... I have an expression that calls a vba function to collate records from all of the notes resulting in a long field. ... Historically, there have been character-count limit problems when Word gets data from Access memo fields (e.g. the limit for ODBC connections was increased many years ago, I haven't researched the Access limitations" problem anything like as much as the equivalent problem in Excel. ... The other field-based technique requires you to have a "parent" table as the mail merge data source and a child table inserted using a DATABASE field. ...
(microsoft.public.word.docmanagement)
Re: Form Advice Relating to Queries
... books, Mastering Access 2002 Premium Edition, Access InsideOut 2002 by Helen ... For more complex queries, use vba programming..... ... I haven't quite worked out how to use the Query Builder via ... ... The form's RecordSource property is a string. ...
(microsoft.public.access.forms)