Recent content by stephena

Thanks again for your help Brian.

Thanks Brian, If I had of read DCRake's response properly I would have realised what was wrong with the AND operrator. It makes sense now. Your query works a treat with a couple of minor alterations. See below. I've bolded the changes. SELECT Title_table.TitleID...

Thanks Brian, With a few twqeaks I managed to get your query to work. However I am still getting the same Result when doing using an AND operator in your third query. It behaves teh same way as my original query where no results are returned using the AND operator. Whereas it behaves as...

Hi Just wondering if anyone can help me out with this query. I am unsure how to incorporate the aggregate function into the query. Any assitance would be very much appreciated.

Thanks Gentlemen. I think I conceptually understand what you are talking about. I'm not sure how to put that together into a query. Can you help me out with an example. Regards Stephen

I've got a problem with a query that I am putting together. I have two related tables. One containing keywords (Assigned_Subject_Keywords_Table) related to records in the first table (Title_table). I am trying to search for records in the Title_table that may be assigned to multiple subject...