Use report to Calculate sum and percentage

[bangemd]

Hello everyone



I have a query that I want to create a report out of but I don't know where to start I know the general calculation and can do it pretty well in excel however I'm completely ignorance when it come to access. Any way here my problem

I have this Query:

SELECT [Phase ID].[Phase ID],
 Count([Phase ID].[Phase ID]) AS CountofPhaseID, 
Count([Phase ID])/(Select Count([Phase ID]) from [Phase ID]) AS [% compare to total], 
Sum(IIf([Phase status]="COMPLETE",1,0)) AS [TP Completed], 
Sum(IIf([Phase status]="IN PROGRESS",1,0)) AS [TP In Progress], 
Sum(IIf([Phase status]="ON HOLD",1,0)) AS [TP On Hold], 
Sum(IIf([Phase status]="ASSIGNED",1,0)) AS [TP Assigned], 
Sum(IIf(IsNull([Phase status]),1,0)) AS [% of Untouched]
FROM [Phase ID]
GROUP BY [Phase ID].[Phase ID];

The Query look like this


this is What I wanted the report to look like.


Please help Thank you In Advance

[bangemd]

Ok I figure it out,

Create multiple query and report then Drag and drop.

Thanks guys for checking this Thread out.

[RuralGuy]

I love it when posters figure out their own problem. There is learning happening here.

[bangemd]

haha but there is alot to learn still