Hi I have got a query which works out the number of days since the person was last admitted to us, and from this I can work out if they came back to us within a specific period e.g. 14/ 28 days. The problem I am having is that the query works out if
they have been readmitted after a DAY, but i need to work out if they have been readmitted on the same day too. My query doesnt currently do this.
I have got a time field in the database which i could use to work it out, but i am not sure how.
Would i need to use a LOOP? I have never used one of these before, so not sure if it could help. Here is a simplified copy of my query below: