specialised report

[NightFeeder]

Hi,

Below is a sample table (exapmle) with a primary key (ID) and two fields.
I would like to generate a report (RptExample) which lists the name and next to each name a count for each of the State field.

How do I go about to create this report?

Table: Example

ID Name State
1 aaa 1
2 aaa 2
3 bbb 2
4 aaa 2
5 bbb 2
6 aaa 2

Report: RptExample

Name State: 1 State: 2
aaa 1 3
bbb 2

Thank you for your trouble.
NightFeeder

 

[ZmrAbdulla]

Try a crosstab query as the recordsource of the report.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Even a thief takes ten years to learn his trade.

 

[NightFeeder]

Thank you very much, Zameer.