Sorry SS I did get the query to work. I just pasted it in the select and subquery the same way which I thought I have tried earlier....but it worked...

I really wish that I could change the table structure. I am not sure why it is set up this way, none of the data is that large in the...

The text field is subabstract sorry about the formatting..I thought I highlighted it.