I have a text field that has a field named ICD-Code that looks something like this:
J10 K1042J108 Z03 Z0311J14 ....
Basically a field that has multiple ICD alphanumeric codes within in where each code can be from 3 to 5 in length, where blanks are placed for codes that do not have a length...
Heya bit of a newbie to OLAP and am hoping this hasnt been answered.
I have a cube that has been setup with client geographic/sub region hierarchy. It also has a sex and agegroup groupings attached... I want to create a calculated measure for future projected populations using a link to an...
Thanks for the prompt reply again... Still couldnt get it to go in Access, so went down different path with SAS and managed to get the outputs required :)
cheers for the tips/code examples
Thanks again for the prompt reply, unfortunately with this i get no results at all with test data :(
Basically this is a query that needs to output number of times a person[UN] is readmitted into an organisation[Org] with 28 days for each visit...
Your initial code was getting there but I...
Thanks for that is a good start!!! Kinda there... the below is an some test data:
org UN admdate sepdate
5 666666 2/02/2005 4/02/2005
5 666666 5/02/2005 7/02/2005
5 666666 8/03/2005 9/03/2005
5 666666 10/03/2005 12/03/2005
6 666666...
Heya, getting back into utilising Access, and have searched this forum finding kind-of related answers but no real definitive solution...
I have a table with the following fields:
[Org] [UN] [ADMDATE] [SEPDATE]
23 001 28/03/04 29/03/04
23 001 01/02/04 03/02/04
23 001 20/02/04...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.