I have an Access97 database with a field that holds codes in it. The codes are three numeric characters then a - and a letter. I want to count and group by the numbers only. Then print them on a report that includes both monthly and annual totals. I think I wrote the query wrong, but I can't get the report to come even close to what I need. Mooo... 