Select Query

[benwo]

Hi

I have a simple select query that pulls data from a table in a sql db. the query shows all records for "agent1". if agent1 has made numerous entrys it shows all of them

how can i get it to just show the total of all entries?

i've tried selecting the sum option in query design but it says data type mismatch in criteria expression

Any ideas?

Thanks

Ben

 

[Smart]

In your query select agent1 ad a new column Agenttot:agent1
click the Totals Icon on the toolbar
In the total section of the column Agenttot change group by to count