consolidated 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 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]

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.