I am having some issues figuring out how to display a progress bar per record in my report in Access 2010.
I have two fields called CurrentProgress and ProjectDays. My intention is to divide CurrentProgress by ProjectDays to get a percentage of progress.
My other option is a field called ProcessStatus which has a value of 1,2,3 and 4 (corresponds with Design, Build, Inspection and Lab). I could use this information also to reflect the progress if I need to.
Is there a way to show in the report, per record a line or rectangle with that percentage (or process status) displayed? Like a bar graph. I have tried so many things but am at a loss for what to do. Anything will help!
I have two fields called CurrentProgress and ProjectDays. My intention is to divide CurrentProgress by ProjectDays to get a percentage of progress.
My other option is a field called ProcessStatus which has a value of 1,2,3 and 4 (corresponds with Design, Build, Inspection and Lab). I could use this information also to reflect the progress if I need to.
Is there a way to show in the report, per record a line or rectangle with that percentage (or process status) displayed? Like a bar graph. I have tried so many things but am at a loss for what to do. Anything will help!