Recent content by Joey_S

Oh my God, it worked. Harry, you are a star! Sorry about your 1p though. D'ya think we should have a NHS Information Forum? Do we have one already? Thanks guys, that's made my day. Joey.

Okay, sorry to ask for help again, but... The excel solution works great - nice and simple, just like me. However, if I want to analyse several wards, it gets a little unwieldy. I can use it for totals and one ward at a time, so thanks for the suggestion. Now, it seems I need to use this...

Wow, thanks Harry and Col. I shall have a play and let you know. Yes, PAS should have this report set up. But don't get me started on that one... Thanks guys Jo.

Hi Col, Well, yes, I do work for an NHS Info Dept, and thats exactly the report we need! We used to have one set up in our PAS, but we changed PAS system last year and haven't been able to report on occupancy since. You're an absolute star if you know a way to do this. Joey.

Thank u for responding. Might just be me being stupid, but... what do I use as a column heading? If I use Start Date, it'll give me number of admissions per day. If I use End Date, it'll give me discharges per day. I don't want either. How do I get a count of people for each day inbetween...

Hello again, I've asked before, but I'm not sure Access can do what I want. I know about DateDiff() & it doesn't do it for me. I want a report with each calendar day as a column heading. I want the number in hospital as the value. I only have the start and end date, is there a way of...

Thank u kindly, Jack, but doesn't DateDiff() just give you the number of days/weeks/years etc between two dates? I want number of people for each day between two dates. EG a patient is admitted 1st March and discharged 15th March. How do I get from that a report with the date: 1st, 2nd, 3rd...

Help! I want to produce a query/report that gives me the number of people in hospital each day. Basically I want dates(days)as a column heading. However, I only have the start and end dates of each patient's stay in the table. Is there a way I can reduce this down to numbers per day? Am I...