I can do a count using "count()" etc and this is fine but alongside this i would like to use total but i keep getting error reports. Can anyone help???

Select SomeField, Count(*) As Total
From YourTable
Group by SomeField;