struggling to design this particualr report. Help me

[kavya]

I have a 'Company' table
The primary key of company table is 'CIK"

Company table has fields 'Type_Org' 'Sec_region' 'state_code'

They should be first grouped by region, and then by state and number of records should be calculated from each state and withing the state they may belong to different organizations.(type_org)There are 5 type orgs. 'S', 'P', 'C', 'L' and other.
Count of records with each type of type org, say how many with 'S', how many with 'P', how many with 'C' within that state.
Please some one suggest me and help me a way to design this report.
Thanks

 

[dawnd3]

well let's first start out by getting the report grouped the way you want it without the counting. You can do this easily through the report wizard when it asks you how you want to view your data and if you want to add grouping levels. After you get the report set up, let me know, and then we can work on getting the totals you want.

Dawn

http://www.calliopeconsulting.net