eager2learn
New member
- Local time
- Today, 06:53
- Joined
- Apr 6, 2010
- Messages
- 2
Hello, I'm new here so sorry for any mistakes
I am going to try to explain this as comprehensively as I can as I know how frustrating it is to be asked a general and broad question.
The actual file has 60,000 records. But, I have attached a sample of 20 records.
There are 16 children but 20 records in the database.
13 of the children have 1 episode.
2 of the children have 2 episodes
1 of the children has 3 episodes.
The problem I have is I want to assign a priority number for analysis to the duplicates and filter based on this number.
If a child is invited for immunisation and is immunised. This episode takes precedence of all other episodes (e.g. with an outcome of deferred, could not attend). (assigned a priority number 1)
However, if two episodes show an immunised ouctome then the most recent one is counted. (assigned a priority number 1)
At the end, I would like to end up with a list of just individual records excluding the duplicates by having them prioritised based on the above criteria.
I know this can be done. Unfortunately, I just don't have the vocab to articulate the query!
Ideally, if this could be done in excel that would be better for me but I know Access is more powerful. For those who do not know, I am a beginner at Access and SQL. If this is the wrong place to post this query. Sorry. Anbd, if anyone has any suggestions on places which may be more appropriate I am all ears.
Thanks again for all your help
I am going to try to explain this as comprehensively as I can as I know how frustrating it is to be asked a general and broad question.
The actual file has 60,000 records. But, I have attached a sample of 20 records.
There are 16 children but 20 records in the database.
13 of the children have 1 episode.
2 of the children have 2 episodes
1 of the children has 3 episodes.
The problem I have is I want to assign a priority number for analysis to the duplicates and filter based on this number.
If a child is invited for immunisation and is immunised. This episode takes precedence of all other episodes (e.g. with an outcome of deferred, could not attend). (assigned a priority number 1)
However, if two episodes show an immunised ouctome then the most recent one is counted. (assigned a priority number 1)
At the end, I would like to end up with a list of just individual records excluding the duplicates by having them prioritised based on the above criteria.
I know this can be done. Unfortunately, I just don't have the vocab to articulate the query!
Ideally, if this could be done in excel that would be better for me but I know Access is more powerful. For those who do not know, I am a beginner at Access and SQL. If this is the wrong place to post this query. Sorry. Anbd, if anyone has any suggestions on places which may be more appropriate I am all ears.
Thanks again for all your help
