How to select the first field in VBA?

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

Rick Brandt

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(*).
 
T

Tim

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

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

Problem defining a variable when reading a table in VBA 2
Recirdset for unqual table 1
Utilizing Recordset field in vb Requery Command Verbiage 1
Second Report not printing - whats wrong with the VBA I have?????? 1
Passing and using field name strings to vba 2
Access Compare records in same access table 0
Update query using Count 4
How to write a parameter query in recordset 3

Top