Recent content by joehands1980

Thanks for taking time to reply. I do this manually just now but I am looking to have a query with each day displaying this value automatically as the number of attenders changes daily 01/11/2016 - 55 min wait 02/11/2016 - 75 min wait 03/11/2016 - 69 min wait

Hi, Looking for a bit of advice, I have a database which logs attendances and I am looking to extract a value from a field which equals 95% of the total attendances. For example I have 160 attendances and I need to know the wait time for the person that equals 95% of 160, in this case the 152nd...

Your a star this works perfectly for my issue, thanks very much for your help :D

no at present it is stored UniqueID Date Location DaysBetween 1 01/01/2013 1 0 2 02/01/2013 2 0 3...

It just gives me back zero's as it is calculating the min and max on the same incident date

These take place in different locations, so as as I bring this factor in it might not work but it should give me what I need just now with some manual intervention, I will try this also, thanks much :D

Cheers will give it a go just now :D

I have a record with a unique ID of when someone had an accident, a new record is created for the next one, as so on each with different dates and I want to say the first to second was 10 days, second to third was 15 days, I have worked out the date diff between them but struggling on how to get...

Hi, looking for a bit of help, I am trying to calculate the number of days between incidents and was wondering if anyone could help out on how to run this. If I have an incident that happened on the 10th August and another on the 15th August then this would be 5 days, the next incident...