Hello,
Ill post the SQL of a query I'm having issue with:
Code:
SELECT JobT.Project_ID, Count(JobT.Date_Complete) AS CountOfDate_Complete, Count(JobT.Job_ID) AS CountOfJob_ID, Sum(JobT.[removed from scope]) AS [SumOfremoved from scope]
FROM JobT
GROUP BY JobT.Project_ID
HAVING (((JobT.Project_ID)=[Forms]![background form]![Project]) AND ((Sum(JobT.[removed from scope]))=True));
I'm using a few querys (this being the first) to work out the percentage of work complete on a project. Then show a graphic to represent the work complete.
Problem here is.... If the query returns nothing. There is no corresponding image to display. The form in this case will go totally blank.
So... I need data..(or a suggestion for a workaround)
Is it possible to have something that will show a result if there is not one to display. (hopefully that made sense).
Just as an FYI and an example. A project may be totally new. So the project does exist... But it has no relationship to any Jobs. This is one of the ways this error occurs.
Any/all advice appreciated.