SELECT STATEMENT

[taqmeena]

in Ms Access VB Code
i want to retrive total number of rows in from a table and store this count is some variable for further manuplation.

who can i do so.
for example:

DIM CNTR AS INTEGER

DoCmd.RunSQL "Select Count(*) from Student"

I want to store the query results in variable CNTR for further working in an event of a text field.

kindly tell me the method for query so that results are stored in a variable

thanking you in advance

 

[KenReay]

You need to use a recordset

depending if you are using ado or dao see CurrentDB(), .OpenRecordset, Connection in help

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[PHV]

CNTR = DCount("*", "Student")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886