Recent content by djridge100

Hi Rabbie, Not to worry, I've just managed to solve it in another way. What I've done is create a new table that just holds the 9 journal codes. I then created a query that shows the journals the customer is subscribed to. I then used the 'unmatched query' wizard to compare the results of...

Thanks for the very quick reply! However, I've tried what you suggested and the query doesn't return anything. Any ideas Rabbie, or any one else? Thanks, Richard.

Hi, I have a table called Customer_Subscriptions (sample data for this table is shown below). Customers_ID Journals_ID M31987 EJTH M31987 ETHM M31987 EVAN M42546 SCCB M42546 TRAN I have the following SQL query to show journals...