Sorry Frank next time I shall try and follow the etiquette.

I adapted rttompkins query by creating a view from his first query and then combining this with the tempbookings table...

I have been struggling with the replies recieved so far and getting nowhere.  Maybe I should explain better.

Table name Tempbookings

Fields, app_id, start_date, End_date

For each app_id I need to find the...

Thanks guys, apologies accepted.  Guess I was just feeling paranoid. 

Always found this forum very useful.  Lots of expertise out there and you've never let me down.

You never know, one...

David,  Thanks for your help it works a dream.

Regarding the funnies, I will take them in the spirit they were meant (I hope)

Were you never beginners????

Thank you everyone!  After a few false starts I finally got there. 

The last two postings from Jean-Pierre and AKM really helped to make it clear where I was going...

Thanks everyone.  I'll try these out on Monday.  Knew it would be easy for the "Old Pro's"

Hmmm!  Me too.  I'm sure we did something simple in SQL Query Manager such as OUPUT TO DISK OR INTO or something.

I'm sure the other answers work but I was...