Count records in Different tables 1

[BrenoAguiar]

Is there a way to count records from a different table or query other than the one that my report reads from?

 

[hkaing79]

DLookup("Count(Field)","table")

 

[PHV]

The usual way is:
DCount("Field", "Table")

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

 

[PHV]

The usual way is:
DCount("Field", "Table")
And if you want the null values counted too:
DCount("*", "Table")

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