Creating a report range

[daveblanch]

Hi all,

I'm using Access 2010.

I'm looking to build a report that summarises the number of completed tasks, calculates the % complete for a given Name then groups them into a percentage range, ordered highest to lowest.

Query fields: Date, Locality, Name, Task, TaskStatus (Criteria of 'Completed')

The date field will look at months, then the user selects a start and end date from the form to summarise the results.

I need to build a report that will group on Time Period, Locality then Name and show:

Count of Name completed 76-100% of actions
Count of Name completed 51-75% of actions
Count of Name completed 26-50% of actions
Count of Name completed 1-25% of actions
Count of Name completed 0 of actions

I just can't seem to get my head round how to do it. I've tried searching but can't seem to find a suitable search term!

I hope I've explained myself, help please!

 

[JHB]

You can do it using 2 queries.
First one counts all action per task.
Second one count all action per task which is completed, link to the first query, then you can calculate the percent, use a UDF or some Iif structure to put it into the percentage range.

 

[daveblanch]

Thanks, worked a treat.

I ended up using a nested Iif to set the grouping.

 

[JHB]

Good you got it to work.