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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Repeat macro until record count of query = 0 0
Access Dcount (multiple criteria) 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
How to count table records in a macro 1
How to Populate Data from a table to another 0
Record Macros in Access 2003? 1
Excel Excel down arrow macro problem 1

Back
Top