calc in a query

[sadie]

I have a database where I record my clients visits(sessions)
I have a field with the number of sessions allowed and another with the session history
I would like to know how to query the table so as to total the number of sessions for each

client

 

[Mile-O]

SELECT Client, Count([Sessions]) AS TotalSessions
FROM MyTable
ORDER BY Client;

 

[sadie]

thanks I will try this

 

[dcx693]

Don't forget to close Mile's parentheses.

 

[Mile-O]

I'll do it.