Calculating a percentage of attendees on access

[jambon87]

Hi

I am trying to create a report to allow me to find the percentage of people who have attended a training course.

The format is in date form, and i am wondering if i am able to calculate the percent of attendees from a list of dates.

I have tried using count function but i cant seem to get it to work

Thanks

[twinnyfo]

jambon87,,

Depending on how your report is set up, you might be able to group the report by attendance date, count the attendees on that date, and then in a separate text box, divide that value by the total number of attendees.

Please provide more information on how your report is set up.

[jambon87]

the report is very basic, infact it was created using the report wizard!

It shows a list of attendees and the date they attended , it also includes a list of people who did not attend. I need a field to show how many people attended and the percentage of people over all who attended.

I hope this helps. I am a bit of a novice when it comes to Access.

[twinnyfo]

Does your table have a field that indicates attendance only (i.e. a Yes/No check box)? Or, do you know whether someone attended based on the date alone (i.e. a date indicates attendance, whereas no date indicates they did not attend)?

Either way, this should be pretty simple. Just insert a text box in the report with a control source of the following.

For a Yes/No Checkbox:

=DCount("*","TableName","[CheckBoxName] = True")/Count("*")
 

Or, for a Date field:

=DCount("*","TableName","IsNull([DateField]) = False")/Count("*")
 

I hope this gets you pointed in the right direction!

[zmbd]

We need the underlying query/table feeding your report.

However, to get you in the correct frame of mind :)
I you can get a sum or a count then you can get the rest.

http://office.microsoft.com/en-us/ac...001122444.aspx
-z