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

Check Access Help topic "Create a crosstab report.

--
HTH
Van T. Dinh
MVP (Access)



"Ramesh" <ramesh2020@gmaildotcom> wrote in message
news:(E-Mail Removed)...
> 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
>