Consolidted report

[Ramesh]

Hi,

I have a table in access with the fields Date and Enquirytype. There are 5
enquiry types. I require a report that gives monthwise the number of each
enquiry type. for eg. in oct 06, how many records have A type enquiry. Say
the columns with enquiry type and the rows being the months.

can i do this in access or is this easier done in Excel? Could someone give
some pointer? I ve been using both excel and access for long but not
anything done anything advanced like reports.

Thanks
ramesh

 

[Van T. Dinh]

Check Access Help topic "Create a crosstab report.