total number of records in the table

H

hngo

Hi,

is ther anyway i can use coed to display the total number of records in the
table?

many thanks in advance
 
D

Douglas J Steele

Actually, you should use DCount("*", "[TableName]")

DCount ignores records that contain Null in the referenced field, so the
count when using a particular field may be off (unless you're sure that
there are no Null values in that field)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Dennis said:
DCount("[AnyFieldNameInTheTable]","[TableName]")

hngo said:
Hi,

is ther anyway i can use coed to display the total number of records in the
table?

many thanks in advance
Click to expand...
Click to expand...
 
Top