Creating a Count Macro

A

Amanda

I need to create a macro that counts the number of rows in
a query and then puts that number in either an Access
table or Excel worksheet.
Thanks.
 
K

Ken Snell

You could use a SetValue action to write a value into a control on a form
(where the control is bound to the field in the table). Use the DCount
function as the Expression to get the value.
 
Top