I have a solution under
However the tMain table can have several models and other lines. The above solution is determinng the percentage based on the total number of frame models in the table.
Looking for a solution for a percentage based on the total number of "MA Health" frameline in the tMain table.
Can the query or the control source of the text box be updated?
Thank you. (Sorry Jeff my sample DB tMain only had one frame line in it... do it wasn't known from the previous question that there could be more than one type of frame line in the table)
Perhaps in the report the text box: =[CountOfFrameModel]/DCoun
n") doesn't account for the frame line of "MA Health"... almost need something like =[CountOfFrameModel]/DCoun
n") where FrameLine = "MA Health"