How to select the first field in VBA?

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi folks,

How to select the first field of a table in VBA? I am
using Access97?

Rst = CurrentDB.OpenRecordset("SELECT Count(" & -
table.field.1- &") AS Count1 FROM EMP;")

I set the table name as a variable and count the records
of the tables. Therefore, I need to select the first
field of any table name.

Any help will be appreciated.

Thanks.

Tim.
 
Tim said:
Hi folks,

How to select the first field of a table in VBA? I am
using Access97?

Rst = CurrentDB.OpenRecordset("SELECT Count(" & -
table.field.1- &") AS Count1 FROM EMP;")

I set the table name as a variable and count the records
of the tables. Therefore, I need to select the first
field of any table name.

Any help will be appreciated.
Click to expand...

Just use Count(*).
 
Rick,

Thanks a lot.

Tim.
-----Original Message-----


Just use Count(*).


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.
Click to expand...
 
Back
Top