Calculate percentage completion of tasks

A

Access lightweight

I use a database for PM task lists and i want to monitor completion
percentage. I access a form which runs a query that returns a list of all
tasks which need to be done. I change the date completed to today on each of
the lines/tasks which I got done, and I would like access to give me a
percentage complete (# of tasks which had their date chaged over the number
of tasks returned by the query) or if it could just give me the total number
of records which I changed the date on and the total number of tasks which
were up for completion. Thanks for your help!!
 
K

KARL DEWEY

Access will not know which records that you change dates. You need to have a
DueDate field and a Completed field. Then you can compare count of DueDate
in your time frame, using Between function, to the count of Completion Is
Null.
 
Top