Creating a Count Macro

  • Thread starter Thread starter Amanda
  • Start date Start date
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.
 
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.
 
Back
Top