Hi
I am very new to Access, but I have managed to do most of what I want to so far with the aid of a book and the internet. However I am now stumped - I want a report that will summarise all the records in the database and give me totals only of all the people living in each State eg CA 25, VT 5. I have fields ID, lastname, firstname and State, but State is the only field I am interested in.
I have tried to do this using a query with the Summary Options but it does not work as Access will only accept ID in the Summary Options (probably because it is a number). I have also tried doing it from a report but this does not work either - I can get a total of all the records but not a total for each state.
Can someone please point me in the right direction?
Many thanks
csiro