How can I implement the Excel COUNTA function in an Access query? herman
M Michael Hopwood May 25, 2004 #2 Use the Count() function in SQL (look in help under "aggregate queries")