Help with A report and Form Combo

[cdogstu99]

I have a query which provides me with the following 4 fields: Company Name, Co or Association, Date, and Tier Number.
It looks as follows:


Company Co/Assoc Effective Date Tier
AAB Company 8/7/2004 5
AAB Company 8/7/2004 3
AAB Company 8/7/2004 5
AAC Association 2/1/2004 1B

I have a form in which the user inputs the beginning and ending date, and selects a Company Name.

I'm trying to create a report from the form, in which for the company and dates selected by the user it lists the count for each tier. So for example a list as follows

1 10
1B 5
2 4
3 2
3A 1

Could someone inform me how to get these values onto my report.

Thanks,
Chris

 

[cdogstu99]

I forgot to mention that I also needed it sorted by Association or Company,

so to revise what i said earlier...it would look more like this

Tier Company Assoc
1 6 4
1b 2 3
2 4 0
3 1 1
3a 0 1

Thanks!