[AccessD] A2003: Left Join problem

Gustav,

Ah! I created the filter query and saved it. Then I used it in my LEFT
JOIN query. Voila! Boy! That seems like more work than is necessary,
but it does the job. Thank you.

Steve Erbach

On 4/25/05, Gustav Brock <Gustav at cactus.dk> wrote:
> Hi Steve
> 
> You need to move the filtering to a subquery. Then left join that and
> not the unfiltered table.
> 
> /gustav