Search results

I can't post the db, there is sensitive information. Is there a way to force the full output list besides using a join property?

That didn't do it. Any other idea. I made the join changes but I am still getting the same results.

So I have a table "compliance" with field "department". The "department" field is linked to a look-up table "lkdepartment" using a numerical value. I have my query below: PARAMETERS [Start Date] DateTime, [End Date] DateTime; SELECT [compliance].department...

I have a query that is pulling compliance for every department. The table I am querying uses a look-up table for the service name. My table does not have data for every department, but I want my query to return every department whether they have data or not and to mark them as zero. Any ideas...

Get those two queries together and then a third to make the calculation