I have a 2003 Access report pulling data from a qeury using:
SELECT tMain.FrameModel, tMain.FrameLine, Count(tMain.FrameModel) AS CountOfFrameModel, tMain.Status
GROUP BY tMain.FrameModel, tMain.FrameLine, tMain.Status
HAVING (((tMain.FrameLine)=[ENTERFRAMELINE]) AND ((tMain.Status)<>"Cancelled"))
ORDER BY tMain.FrameModel;
In the report detail I have a text box displaying CountOfFrameModel which is showing the toal number of models. The report is fine but instead of displaying the total number I would like to have the report display the total of all frame models based on ENTERFRAMELINE in the table as a percentage for the total number of ENTERFRAMELINE
I think I just need to somehow get a grand total of the number of ENTERFRAMELINE entries found then I can do some basic division with that number to get a percent.