Report with several counts

[njitter]

Hello,

i need to create a summary report for the following database:

The report needs to look like this:

I have never done such a report before. Can someone explain to me how to setup such a report?

---
It's never too late to do the Right thing

 

[njitter]

Follow-Up:

I've created the following Queries:

- Active
- Finished
- Too Late
- Within Deadline
- Projects

The task left is to generate the table.



---
It's never too late to do the Right thing

 

[dhookom]

Your report looks like a crosstab. There are several examples of crosstab reports at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

I don't think you would need separate queries for Active, Finished,...

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]