[AccessD] A2003: Left Join problem

Mark, Susan, Liz,

Thank you for the instant response to my problem. I appreciate it very much.

Steve Erbach

On 4/25/05, Mark A Matte <markamatte at hotmail.com> wrote:
> Steve,
> 
> ...or you can add criteria to your date field to include NULLS in addition
> to the dates provided... DollarsDonated.ReceiptDate=null.
> 
> Mark
> 

>   It's a conflict to return all on one side but limit the other side with a
> WHERE -- can't do it I don't think.
>
> Susan H.

> Steve,

> If you have no donations for a particular category, the
DollarsDonated.ReceiptDate date is null.  So you are disallowing categories
with no data in that field.
> 
> Liz