Get total number of records in a table and show it

[nissan240zx]

Hello All,
I am trying to find a method to display total number of records in a particular table and display that number on my switchboard window.

Any leads.

Thx in advance...

A good programmer is someone who looks both ways before crossing a one-way street. - Doug Linder

 

[PHV]

Have a look at the DCount function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nissan240zx]

Can I use something like DCount *.tablename

A good programmer is someone who looks both ways before crossing a one-way street. - Doug Linder

 

[PHV]

When in VBE (Ctrl+G), type dcount and press the F1 key.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nissan240zx]

I checked and this supposed to be the syntax
DCount («expr», «domain», «criteria»)

So if my table name is firm_records_05 then how do I get total count of records.

A good programmer is someone who looks both ways before crossing a one-way street. - Doug Linder

 

[PHV]

And the examples in the help doesn't help ?
=DCount("*","firm_records_05")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886