Forum Discussion
Project Management Access Fix?
Hi I have just begun using the template by Microsoft access that is for project management. I have posted below a screen shot of what I'm encountering. My access is showing a completed job under my project task tab. I only want this to show jobs that are active. Is there a way to fix this or filter it?
In the query that provides records for this report, add a where clause to restrict records to those projects not in the completed status. This could be one of two possible variations, depending on the tables and fields.
WHERE ProjectStatus <> "Completed"
or
WHERE ProjectStatus <> 1, where 1 is the Primary Key for the ProjectStatus "Completed" in the ProjectStatus table.
Unfortunately, I don't see a table that would be "ProjectStatus", so I'm afraid that the statuses are a value list which includes "Completed". That would lean towards the first option.
Clarity depends on greater detail about the tables.
