Selecting a column without knowing its name

[Rob Tiemens]

hello,

I need to select the first and the second column of a table. But I
don't know the names of the columns.

Is there any way I can select only the first column from a table
without knowing the columnname ?

Regards

Rob Tiemens

[Tom van Stiphout]

On 15 Apr 2005 01:04:15 -0700, ro********@gmail.com (Rob Tiemens)
wrote:

You could create a dynamic SQL statement. Something like:
dim sql as string
dim db as dao.database
dim td as dao.tabledef
set db=currentdb
set ts=db.tabledefs("MyTable")
sql="select " & td.fields(0).name & "," & td.fields(1).name & " from
MyTable"

Now you can use this sql as your form's recordsource or as the basis
for opening a recordset, etc.

-Tom.

hello,

I need to select the first and the second column of a table. But I
don't know the names of the columns.

Is there any way I can select only the first column from a table
without knowing the columnname ?

Regards

Rob Tiemens