The second date was a typo they should all have been on the same day (the 1st) - although it is perfectly feasible that the date could be the next...

Noel

Say for example someone is at a location for two periods in one day. The only way I can tell from the data that I have available that they have...

Frank

You got it in a nutshell, I have vastly simplified the data, however there are good reasons why things like exit date are not available. The Exit date (and therefore...

Frank Kalis - Thanks for your reply much appreciated. Whilst your query does exactly what I want in terms of the data shown above - it only works if there...