Store count

  • Thread starter Thread starter SAC
  • Start date Start date
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.
 
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
 
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
 
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...
 
You must log in or register to reply here.

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

How to reference a field of a recordset with a variable 4
Having trouble with code 2
"working days" function (part days) 2
How to Populate Data from a table to another 0
Outlook generates error when accessing rules - Please help. 1
help with code on event call 3
Problem converting from VB6 to VB.net 2
Have a count in % 1

Back
Top