Getting a count of a query to a Text Field

[rockyjr]

This is probably easy for some,

Using VB, is there a way to run a query from a form (by clicking on a button), then count the number of entries found and send the results to a text field? If there is not entries found, the text field should display 0.

Thanks for any info,

Luc

 

[namliam]

Check out the DCount function

 

[PaulJR]

You can add a command button to run a query by using the control wizard.

To count the total number of fields, you can use something like this in the Row Source text box:

SELECT Count([fieldname]) FROM QueryName;

 

[rockyjr]

thanks both of you.