Record Count

SteveE

Registered User.
Local time
Today, 03:13
Joined
Dec 6, 2002
Messages
221
I have 8 tables which I need to count the records in, I want to display results of the count on a form, I have a method which seems very long winded and I am sure there will be an easy solution in vb that one of you helpful people will advise ?

On a Form when opening I need;

Table 1 = "records"
Table 2 = "records"
Table 3 = "records"
Table 4 = "records"
Table 5 = "records"
Table 6 = "records"
Table 7 = "records"
Table 8 = "records"

Any advise apriciated.
 
Last edited:
You could use the DCount function
 
Thanks!! Just need that kick in the right direction
 

Users who are viewing this thread

Back
Top Bottom