MuleBruiser63
New member
- Local time
- Today, 17:54
- Joined
- Feb 16, 2018
- Messages
- 2
Hi all,
I am a beginner with Access 2010 and this is my first post. I have searched extensively for weeks on this forum and elsewhere and have not found a solution to my problem. I have figured out how to run all of my queries/calculations except for one thus far in my research database. I would like to be able to calculate the percent change between fields for a Unique ID but not have the calculation run between next set of fields when moving onto the next Unique ID. The Medical Record Number (MRN) is the unique ID that I would like to run my query on. It would be simple if I did not have that much data as I could pull out each MRN and run a query, however I currently have > 1500 scores for > 200 MRNs so I was hoping to pick everyone's brain to see if they have a solution, or if I need to figure this out in Excel or just breakdown and get a separate statistical software package. Any help is much appreciated. Thanks!
My table is set up as such MRN, VisitDate, Score.
Sample Data Is:
MRN VisitData Score
1 7/1/2016 9
1 8/1/2016 6
1 9/1/2016 3
2 2/1/2017 6
2 3/1/2017 0
And I would like the query to show results as such:
MRN PercentChange
1
1 -33%
1 -50%
2
2 -100%
I am a beginner with Access 2010 and this is my first post. I have searched extensively for weeks on this forum and elsewhere and have not found a solution to my problem. I have figured out how to run all of my queries/calculations except for one thus far in my research database. I would like to be able to calculate the percent change between fields for a Unique ID but not have the calculation run between next set of fields when moving onto the next Unique ID. The Medical Record Number (MRN) is the unique ID that I would like to run my query on. It would be simple if I did not have that much data as I could pull out each MRN and run a query, however I currently have > 1500 scores for > 200 MRNs so I was hoping to pick everyone's brain to see if they have a solution, or if I need to figure this out in Excel or just breakdown and get a separate statistical software package. Any help is much appreciated. Thanks!
My table is set up as such MRN, VisitDate, Score.
Sample Data Is:
MRN VisitData Score
1 7/1/2016 9
1 8/1/2016 6
1 9/1/2016 3
2 2/1/2017 6
2 3/1/2017 0
And I would like the query to show results as such:
MRN PercentChange
1
1 -33%
1 -50%
2
2 -100%