Recent content by ericarennie

Hi Nellie Yes nearly.. You have the basic entities Patient Agency (which I am not too worried about keeping in the calculations) Time spent at the agency: triage(first appointment) to discharge Treatments during that time at the agency: treatment start, treatment finish for each type of...

Hi My data base takes information from several healthcare agencies where patients have been treated for various lenghts of time, for different types of treatment. Clients are triaged (/ assessed) when they first present to the agency, and the inital referral and discharge dates can be...

Hi, I hope someone can help me. I have a database as thus: Several tables ->appended together using 'union select' into a query called 'sheet1'-> information that is coded converted via linked tables in a query called 'sheet2' 'Sheet 2' looks completely fine - it works dandy but when I try and...