Excel vs Acess

  • Thread starter Thread starter hermie
  • Start date Start date
H

hermie

How can I implement the Excel COUNTA function in an Access query?

herman
 
Use the Count() function in SQL (look in help under "aggregate queries")
 
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

problem with query 1
Making it more user friendly 2
Exporting queries... 3
Access #Error & Excel Pivot 0
changing a number to text 1
edit data in query 1
Can't update Access fields from linked Excel file 5
Access/Excel discrepancy 3

Back
Top