Calculate Percentages

[TGrady]

I created a table in Access 2007 called "Accidents" . I have a field called
"Fault Description" which allows the user to select the option of "Fault" or
"No fault" from a list. In the report footer, I want a number to reflect the percentage of records that have the option of "Fault" selected. I want to run this report by date range, i have already added the date field.

[rwalle]

create a query with parameter to restrict the dates then based on this query create a second query to obtain the "fault" count , and other query to "No fault" count, then create a form with 2 unbound date fields that ask for initial and end dates, and a button to run a report based on the parameter query, you can now see all the registers within your dates window and in the report footer you can write down the "fault" and "No fault" total counts and create a new calculated field that give you a percent of "Fault" over "No fault" or over Total register count

[ADezii]

Here is the general idea without the Date Criteria included. To include the Percentage of Faults in the [Fault Description] Field for all Records in the Accidents Table, place the following Expression in the Control Source of a Text Box in the Report's Footer:

=Format(DCount("*","Accidents","[Fault Description] = '" & "Fault" & "'")/DCount("*","Accidents"),"Percent")

[NeoPa]

If your data is shown in a control in the Detail section of the report, then these values can be aggregated directly (You can sum the value in the detail rather than having to use a Domain Aggregate function - DSum() - to process through the data again).

Something like :

=Format(Sum(IIf([txtFaultDescription]='Fault',1,0)/Count([txtFaultDescription]),'Percent')

This will automatically incorporate any date criteria applied to the report.