I have an Access query where I am pulling multiple drug type groups with an amount. I need to be able to only pull the top 2 dollar amounts for each group.
Is there a way to do this? Thanks!!
Ex.
Emergency Meds $4.00
HIV $5.00
Psychotropics $5.55
Topical $10.00
Analgesics $3.78
Emergency Meds $23.95
Vaccines $26.88
Cardiac $34.44
Emergency Meds $1.23
HIV $5.22
Topical $1.22
HIV $3.44
Topical $45.44
I am not going to put in more examples because I do not want my sampling to be too large. I only need to pull the top 2 dollar amounts for each group:
Emergency Meds $23.95
Emergency Meds $4.00
HIV $5.22
HIV $5.00
Topical $45.44
Topical $10.00
etc, etc