Seth - A thousand thanks!!!

Seth my apologies for my rubbish posting

Here is a small set of the data based on the original post

CREATE TABLE visit(

VisitID INT,

StudentID ...

Once again everyone thanks - but i have just been asked to do more reports relating to this DB, based on the query and tables in this post. I need...

That's great - Many Thanks

Great everyone thanks!!

Jack - Will go and give this a try. Once again thanks for all your help!

Great - thanks for that. There is just one thing, any idea how you would go about checking the difference in days just from the most recent record in the...