Search results

I have been doing some trial and error with this and not sure if it is right. This is simple in principle!I have a table with the fieldsEpisodeIDEpisodeDateTimeIs it possible to calculate from this:a) the average time of day episodes occur (mean/median)b) the minimum maximum number of...

My condolences to David' family.Im am not an active member but the times I have been on here David has been selfless in his contributions. Very much a 'giver'RIP David

Hi thereI am trying to work out the average number of episodes per day. I have a tableEpisodeIDDatecould anyone help?

I have a query where one custom field is working out the number of days:HoldDays: DateDiff("d",qry_cardiology1.HoldStartDateTime1,qry_cardiology1.HoldEndDateTime1)My problem is that sometimes there will not be a value for HoldStartDateTime or HoldEndStartTime so I want to add a condition that...

Hi thereI have a working function for Workingdays but esstentially what I am trying toa dd is a function that takes into account a pause between start and end date

thank you DavidI have tried this but it is too long an expression:WorkDays...

Hi thereI have a query of patient episodes that works out the difference between two dates 'RequestDateTime' and 'Procedure1DateTime'.The query takes out the weekend days so only workdaysSometimes though a patient episode may be put on hold using another two...

aha - I have found a way around this by changing the cross tab query: TRANSFORM Nz(Count(qry_cardiology1.EpisodeID),0) AS CountOfEpisodeID SELECT qry_cardiology1.ReferringHospital FROM qry_cardiology1 WHERE (((qry_cardiology1.ReferringHospital)="Dudley" Or...

I know - but the output needs to show the workdays that have '0' under all three referring hospitals as well- for 8,9,10 work days this is mind boggling. I think I am approaching this all wrong Maybe i could have a condition in the countofepisode field that says if result is 0 then add this to...

no - having 'Or is null' under requestdatetime where clause still gives me workdays listed from 1-7. I understand that the criteria is only looking for what I am asking for but I don;t get the bit where I want it to provide the results as listed in my original excel attachment

Already tried that - sorry - you must be thinking what an muppet he is:)

Thought so - but is there a way to add the workdays that have '0' for each of the referring hospitals

Thank you for that vbainet. It works great but a soon as I put a where clause on the cross tab query - in this case where requestdatetime is between and xXXX and XXXX - I get the old results where it only shows workdays 1-7 - or whatever days apply to that date range.

I would have a table called tlb_contact (with the persons contacts details - and a primary key contactid) I would have a 2nd table called tbl_episode with a primary key episode_id but a foreign key of contactid. In that table you would have one or more records of the persons living...

Hi Please see attached Queries in question here are: 'qry_cardiology1' which is generating numberofworkdays and the cross tab query IHT_network_query which is what I am using to view my results and populate the report. As you may notice - this is a reporting tool. The data is pulled...

I am royally stumped lol - sorry vbaInet

Thankyou vbaInet- I created as table called tblDays which has number values of 0-12. The bit where I am getting confused is that the field Numberofworkdays is in a query - not a table. I am not sure how to do joins between a table and a query

Hi - haven't worked on this for a while but have come back onto it today. I am struggling a bit to be honest understanding how to take this forward

No this doesn't pull out the days 6, 10 ad 11

Hi I don't have an inner join in the query qry_cardiology1 SELECT tbl_Data.AdmissionDate, tbl_Data.DischargeDatetime, tbl_Data.EpisodeID, tbl_Data.Status, tbl_Data.Outcome, tbl_Data.ReferringHospital, tbl_Data.ReceiveHospital, tbl_Data.DaysAdmitToTransfer, tbl_Data.DaysRequestToTransfer...