Recent content by myblueshadow

Hi again. Thanks so much for your help. I just got back to work this morning and plugged this in, but it's still not giving me the zeros.

First, thank you so much for helping me!! Here is the sample data: FU kids: AlphaID DtcCtr DlsDtc ABRAJ1 02 01-May-09 ABUKA1 04 01-Nov-09 ACEVM1 05 25-Jun-03 ACOFA1 11 27-Jun-05 ACOFJ1 07 30-Aug-04 MNCPSTNote: AlphaID DtcCtr ServDate ABRAJ1 02 3/12/2009 ABRAJ1 02 4/5/2011 ABRAJ1 02...

I'm trying to do a query to count corresponding records in another table. It works except for returning zeros. I've tried using NZ and switching the type of join, but to no avail. I need help!! Here's what I have: Query A has 3 columns (FU kids) AlphaID DtcCtr (a Location Code)...