Creating a report range

vendredi 20 mars 2015

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!

Creating a report range

0 commentaires:

Enregistrer un commentaire

Labels