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 to export the data to Excel and
generate the report? 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

In Access, you can use the Report Wizard to create a report that groups
the date by month, then groups by enquiry type.
In the report design view, set the detail section to visible=No.
In the enquiry type header, add a text box with the control source:
=Count(*)
If you need help with the report, you could post a question in one of
the Access newsgroups.

Ramesh wrote:
> 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 to export the data to Excel and
> generate the report? 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
>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html