select count of record into variable

[suvagich]

hi,
i want to select total count of records of table into variable.
so how can i do that using select query?

select count(*) into variable
from table ;

is this correct way????

thanx,

 

[pbaldy]

A VBA variable? No, you'd either use a DCount() or open a recordset on similar SQL.

VariableName = DCount(...)

With the appropriate arguments.

 

[suvagich]

Thnx a lot Paul...
your solution worked for me..

thnx...

 

[pbaldy]

Happy to help.