Looks like the calculations are correct.
|
Unfiltered
|
Filtered
|
Specimen Count: |
2,870 |
14 |
Pass Count: |
2,338 |
2,338 |
Fail Count: |
532 |
532 |
Percent Pass: |
81 |
16700 |
|
|
|
What were you expecting?
The calculation for the unfiltered Percent Pass is 2338/2870 = 81
The calculation for the filtered Percent Pass is 2338/14 = 16700
Why isn't the filtered pass count <= 14?
Why isn't the filtered fail count <= 14?
I would add the Specimen Count criteria to the DCount() function: (untested)
Code:
Pass Count: =DCount("[PF]","qryTM00444R1","[PF]='Pass' AND [SpecimenDate] = " & Date() )
Change the red to your criteria that filters the form......