Try this. I just got done calculating percentages on a report of mine.
=(DCount("[Procedure]","tblMyTable","[Survived]=1"))/(DCount("[Procedure]","tblMyTable","[ProcedureID]=243"))
Breakdown:
DCount - counts the number of records in a specific domain (ie table or query)
"[Procedure]" - Field...