Creating a Count Macro

[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.

 

[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.