Hi all,
I have a list of almost 1 million rows of data that contain a charge for every visit a patient had to my hospital. How do I group the costs together to get a total cost for each patient? If the list was smaller then I could dump it in excel and pivot on the patients and sum the total costs. But what is the equivalent of doing that in access?
Thank you in advance for any help you can provide!