If I have a field called DayOfWeek which is a text field containing various days of the week, how can I get a sum total or count of each day of the week. I did create 7 new fields called sum_Sunday, sum_monday, etc. and tried various calculations, but having no luck. I have a feeling I'm over thinking this and making it harder than it has to be. Any suggestions would be greatly appreciated.