I have a Jobs table with Job Header linked via Job Number to Job Labour, Job Stock, Job Direct Issue. I've grouped on Workshop and Job Number. I've experimented with the Joins but can't get what I want. See screenshot - I've added the three fields ...

I have a report with users who have completed a check against their assigned assets within some location and date parameters. I've got a users table, a checks table and an asset table. I have the list of checks and users for the parameters in the rep...

I have a report with a table of users who have completed an action in the last month. I also have a subreport showing all users from whatever location has been selected in the main report. So in the current example I have 41 users who appear in the m...