Can this be done?

[Lyncroft]

This probably sounds very stupid. I've a query that aggregates the number of people who attend each course. In the same query ideally I would like to find out what percentage of total employees attend each course. Because of the table structure I can't do this though I can get a total no. of employers from another table.

When I do the report is there anyway I can make a reference to the total no. of emps so that I can do an expression to work out the percentage.

Sorry to be so garbled! A colleague said "why not write a function?" I would if I could.

 

[Rich]

Why not use a subReport or DCount?

 

[Lyncroft]

Thanks for the help Rich - helpful as ever. How would the DCount/Sub report work. I just don't see how I can get the percentage figure.

 

[Rich]

I assume the Report returns the total employee count for each course, in which case =([YourCountField])/DCount("EmployeeID","Employees")

 

[Lyncroft]

Cheers Rich - I'll take a look at that one.

Thanks again