Need help with Percentages

[Paul B.]

This is my SQL statement:

SELECT Abs(Sum([Form2]="Filed")) AS Unit1Form2Filed,
Abs(Sum([CAMT]="Filed")) AS Unit1CAMTFiled, Abs(Sum([Form2]="Req & Rec")) AS
Unit1Form2ReqRec, Abs(Sum([CAMT]="Req & Rec")) AS Unit1CAMTReqRec,
Abs(Sum([Form2]="Outstanding")) AS Unit1Form2Outstanding,
Abs(Sum([CAMT]="Outstanding")) AS Unit1CAMTOutstanding, Abs(Sum([Form2]="Not
Required")) AS Unit1Form2NotRequired, Abs(Sum([CAMT]="Not Required")) AS
Unit1CAMTNotRequired, Abs(Sum(IsNull([Form2]))) AS Unit1Form2NoInfo,
Abs(Sum(IsNull([CAMT]))) AS Unit1CAMTNoInfo, Count(*) AS Total FROM tblUnit1;


I need to add percentages to each and I haven't had any luck using the
examples from this forum.

Any help would be appreciated.

Cheers