Hello,
I have a table in Access 2003 that is a larger version of this:
Code:
Sample Beetle Fly Moth Spiders
1 4.20 2.30 0.01 1.25
2 2.30 2.00 0.00 3.00
3 3.10 1.60 1.03 2.73
'Sample' is the primary key. I need to determine the percent of the most abundant creature per sample (ie. (# of most abundant creature in sample/total # of creatures in the sample)*100). I already have a query calculating the total creatures (called 'sampletotal') per sample and in the same query I would like to display the percent abundant creature per sample. How would I get access to go through each entry (ie. each sample) and select the field with the highest numerical value so that I could use it for the calculation?
So for sample 1 percent_abundant should = (4.2/7.76)*100 and for sample 2 it should = (3.0/7.3)*100 and so on for each sample