Queries/Reporting

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

A query that checks which employees have a sick leave / other event without supporting documents, that were uploaded through the "attach file" option of the event. That way we can monitor who needs to upload their documents and who doesn't.

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

We would like a report that combines the ATS applicant and employee information. This will enable us to track vacancies filled with the correct information, and remove the need to pull reports then manually consolidate them in Excel. For example a...

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

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

Please could there be an option created to only bring back the most recent record on a logbook query. This would make it so much easier to report on something like someones pension record in the logbook section, only bringing back the most recent ...

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

building hot sheets etc