count number of records in a query

chewy

SuperNintendo Chalmers
Local time
Today, 14:53
Joined
Mar 8, 2002
Messages
581
I have a query(qryMain) that is based on a form(frmMain). I want, on another form (frmDate) to be able to click a button and have it give me the count of the number of records in the query.
 
=DCount("[YourField]", "qryMain")
 
Thanks!

The return of my favorite Avatar!:cool:
 
one more question. Is there a VB code to tab over. Like vbCrLf wil bring you to a new line. I know C++ has one.
 
vbTab

Check the help files for Miscellaneous Constants.

HTH
 
Hey thanks! And thanks for the link
 

Users who are viewing this thread

Back
Top Bottom