Queries/Reporting

building hot sheets etc

I want to be able to run a query that shows the hours absent each day, not the total for the absence. As an example, if someone is absent from 10 to 14 February, I'd like to see a line of data with the number of hours for each day (Monday 10th - 7...

When creating a Query I would like the columns to be in a particular order every time I run / access the query. I select the fields that I want in the Query, and then I am able move the columns to where I want them to be, so that when I export to ...

When certain numerical data is exported to Excel from Queries, it comes out as a text file e.g. length of service dates and dates/days of birth (e.g. when looking at age). This means that when you try to sort on Excel it does it alphabetical rathe...

I often have queries that I need to write, especially for Ripples, where I don't have the flexibility I need in the query builder. I need an IS NOT option i.e. the date was not yesterday or today, and I need a weekend option i.e. the date was not ...

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...

Adding a filtering field for Admins and Managers on 'Date Last Opened' alongside the existing Name, Description and Category will allow for easy tidying up of unused Queries.

You cannot currently build a query that shows if an assignment is part of an approved timesheet. We currently have staff that do assignments but dont send them for approval. The timesheet and assignment can still be approved but when reporting the...

This would be a great benefit to my managers who at the moment are having to work from two separate reports - Using the time sheet report to view and accept late/doctors etc, but then have to move over to the spreadsheet report and open People HR ...

In the planner, the field 'Was your sickness caused by an accident at work or an industrial disease' is a tick box. At the moment, this can't be reported upon in a query. This would be helpful because it would allow a query to easily and quickly s...