My ideas: Queries/Reporting

Access Workspace is built around their Access Data Engine (ADE) allowing you to build Analytics within workspace to combine data from multiple Access and 3rd Party applications and present this consolidated data to selected individuals. It seems t...

We would like reports run to include the line manager/direct report's ID/employee number as a field, as well as the colleagues ID/employee number. At the moment, for a number of reports that include the manager, we are adding this manually.

I needed a list of employees based in each of our office locations as at a historic date. There's no way of doing this under the current query filter options so it would be great for this to be added.

Managers receive email notification for time sheets and then approve and make comments. It would be really useful if we could report on comments made by managers re timesheets as currently no one can see it apart from admin or manager.

For example being able to pull a Length of service report for how many teams will be over 2 years service at a specific date in the future

Add a new option to reports for the full name, to show the first and surnames in the same field. This will be auto populated from the existing first/surname fields, rather than a field that is manually entered for each employee. This will enable m...

The finance team need to be able to print the expense sheet in PDF format for each employee's expenses from clicking the Approved button. Currently they cannot see the whole page unless you scroll down to see all the expense entries, so if you scr...

Create an automated ripple that creates a list of all the employees who show up in a query. One task with the entire list, not multiple tasks with one name. For example - a task saying "update the logbook for x, y, z", when x, y, z are the names w...

I think it would be quite helpful (and relatively simple) to colour code each of the fields in the right hand pane of the query builder along with their corresponding section title in the left hand pane.

It would be cool if you could select a catergory of queries and then have a 'run all' button or if you were able to select a group of queries that you wanted to download at the same time. eg go into Staff List category, select all the queries in t...