I am a complete novice when it comes to VBA programming. I have been looking at the different ways to come up with the 95th percentile in Access, but I can't get any of them to work.
I have a table called Fecal_Adjusted with the fields:
I need to group on the Waterbody_ID and get the 95th percentile for the Fecal field for each Waterbody_ID. The waterbody_ID is a text field.
Any help would be appreciated.