From: jo on
Hi, again

All I did was to replace your suggested �where� state in my query as below,
and then rerun it using the current data in the test database as already
lisedt within these threads.

SELECT A.Date_R, A.Received, A.ID, B.Colour
FROM A INNER JOIN B ON A.Main = B.Main
WHERE A.Received=-1 AND (B.Colour <>"Y" Or B.Colour Is Null);


If you are suggesting that my approach is on the right lines, I will try
debugging the query over the weekend and get back to you.

Thank you for you guidance so far.
From: Marshall Barton on
jo(a)jo.uk wrote:
>All I did was to replace your suggested �where� state in my query as below,
>and then rerun it using the current data in the test database as already
>lisedt within these threads.
>
>SELECT A.Date_R, A.Received, A.ID, B.Colour
>FROM A INNER JOIN B ON A.Main = B.Main
>WHERE A.Received=-1 AND (B.Colour <>"Y" Or B.Colour Is Null);
>
>
>If you are suggesting that my approach is on the right lines, I will try
>debugging the query over the weekend and get back to you.
>

Sheesh, I had a blind spot, sorry.

Try changing the INNER JOIN to a LEFT JOIN

--
Marsh
MVP [MS Access]
From: jo on
Hi
All up and running now.

Thank you for your assistance.