Search results

thanks guys. That works very well Arnelgp. On the original attached example, there is an entry in red where there is only one reponse but 2 questions raised. is it Possible to exclude this one?

I have two tables relating to queries sent in by customers and responses made to them. There can be multiple questions asked and multiple responses given. What i'm trying to achieve is being able to calculate the time taken between question raised and the response. However, i'm getting results...

Hi there, I'm Jon and i'm an access newbie! I'm based in the UK and can get around access a little bit. But i'm starting to want more complex queries and thought i'd join the experts!