Hi and welcome to MrExcel.
Can you explain a little more as to what you want? There are standard count functions available when using totals queries. In your query design screen click View> Totals > in your query grid in the 'Total' row there are a number of options including 'Count'. Or if you are using a select query without totals and want to see a count then there is a DCount function that will do this. We will need some more information as to what you are trying to do before we can properly answer your question.
Andrew