counting fields in access report 1

[Grieve1]

I have a report that has a field Trade and I can place a count function that will tell me individually how many employees have what trade in the Trade Footer, and if I do a count in report footer I get an over all count of all trades. What I want to be able to do is place an individual and overall count in report footer. Any help would be a great help have already seen done but dont know how to do. Thanks

 

[Remou]

It is probably best to use a subreport.

 

[JBinQLD]

How about two running sum fields, one set to over all one set to over group, and then place a control in the footer that has control source of =me!MyRunningSum1 or =me!MyRunningSum2?

You can of course set the running sums to invisble so the user doesn't see them

JB

 

[Grieve1]

Hi Remou I have put in a subreport but it is only picking up last trade don't know why because when same count is done on main form it picks up all

 

[Remou]

Did you put the subreport in the report footer? What was the SQL for the subreport?

 

[Grieve1]

SELECT [qrycounting tradeClockings].Trade FROM [qrycounting tradeClockings];

 

[Remou]

You need something on the lines of:

[tt]SELECT [tradeClockings].Trade, Count([tradeClockings].Trade)
FROM [tradeClockings]
GROUP BY [tradeClockings].Trade[/tt]

 

[Grieve1]

Many Thanks to you all for your invaluable assistance