Store count

S

SAC

I would like to store the count into a variable.

intCount = Select Count(*) from SomeTable doesn't work.

How can I do this?

Thanks.
 
M

Mr. B

I would like to store the count into a variable.

intCount = Select Count(*) from SomeTable doesn't work.

How can I do this?

Thanks.
Click to expand...

Try Dlookup.

Look in the help file.

HTH

Mr B
 
M

Mr. B

I would like to store the count into a variable.

intCount = Select Count(*) from SomeTable doesn't work.

How can I do this?

Thanks.
Click to expand...

Sorry, i meant Dcount.

intCount = Dcount("ID","SomeTable", "IdField = SomeVlue")

Just take look in the help file for DCount.

Sorry for the incorrect post. I't early. :>)

HTH

Mr B
 
S

SAC

No prob! Appreciate the help!
Mr. B said:
Sorry, i meant Dcount.

intCount = Dcount("ID","SomeTable", "IdField = SomeVlue")

Just take look in the help file for DCount.

Sorry for the incorrect post. I't early. :>)

HTH

Mr B
Click to expand...
 
Top