Hi,
I'm using the following query to display total completion % for a project.
How would i include this in my forms to show the value for those records in a text box? please see the attached image.
I'm using the following query to display total completion % for a project.
Code:
SELECT qryProjectSubSubTaskTotalCount.ProjectSubTaskID, qryProjectSubSubTaskTotalCount.TotalTasks, qryPRojectSubSubTaskCompleteCount.CountOfActualCompletionDate, [CountOfActualCompletionDate]/[TotalTasks] AS TotalPercentage
FROM qryPRojectSubSubTaskCompleteCount RIGHT JOIN qryProjectSubSubTaskTotalCount ON qryPRojectSubSubTaskCompleteCount.ProjectSubTaskID = qryProjectSubSubTaskTotalCount.ProjectSubTaskID;
How would i include this in my forms to show the value for those records in a text box? please see the attached image.