Am I using the right query v. Union Query??

[Mennochio]

This is my query:[

SELECT NAIC, [Time to Maturity], RBC_CLASS, SumofBookValue
FROM [qryDUMMIES]

UNION

SELECT [qry ReconD1 Tenure].NAIC, tblWALGroups.[Time To Maturity], IIf(([sec_group]="BONDS" Or [sec_group]="MBS / CMO") And Not ([new_type]="PFD SEC" Or [new_type]="PFD SEC YA" Or [NEW_TYPE]="PFD HYB YA" Or [NEW_TYPE]="PFD HYBRID"),"LTBonds",(IIf([new_type]="PFD SEC" Or [new_type]="PFD SEC YA" Or [NEW_TYPE]="PFD HYB YA" Or [NEW_TYPE]="PFD HYBRID","PREFER STK",IIf(Left([schd_d_code],2)="DE","Cash Eqv",[sec_group])))) AS RBC_CLASS, Sum([qry ReconD1 Tenure].BOOKVALUE) AS SumOfBOOKVALUE
FROM [qry ReconD1 Tenure] INNER JOIN tblWALGroups ON ([qry ReconD1 Tenure].Tenure>=tblWALGroups.GE_LowWAL) AND ([qry ReconD1 Tenure].Tenure<tblWALGroups.LT_HighWAL)
GROUP BY [qry ReconD1 Tenure].NAIC, tblWALGroups.[Time To Maturity], IIf(([sec_group]="BONDS" Or [sec_group]="MBS / CMO") And Not ([new_type]="PFD SEC" Or [new_type]="PFD SEC YA" Or [NEW_TYPE]="PFD HYB YA" Or [NEW_TYPE]="PFD HYBRID"),"LTBonds",(IIf([new_type]="PFD SEC" Or [new_type]="PFD SEC YA" Or [NEW_TYPE]="PFD HYB YA" Or [NEW_TYPE]="PFD HYBRID","PREFER STK",IIf(Left([schd_d_code],2)="DE","Cash Eqv",[sec_group]))))
HAVING ((IIf(([sec_group]="BONDS" Or [sec_group]="MBS / CMO") And Not ([new_type]="PFD SEC" Or [new_type]="PFD SEC YA" Or [NEW_TYPE]="PFD HYB YA" Or [NEW_TYPE]="PFD HYBRID"),"LTBonds",(IIf([new_type]="PFD SEC" Or [new_type]="PFD SEC YA" Or [NEW_TYPE]="PFD HYB YA" Or [NEW_TYPE]="PFD HYBRID","PREFER STK",IIf(Left([schd_d_code],2)="DE","Cash Eqv",[sec_group])))))="LTBonds");

The reason I am doing that is because I want fields that have a 0 sumofbookvalue to show through and I don't get that if I use just the second statement by itself. However, when I do the union, now I have entries for every other combination, but I have a double entry of 0 and a number when sumofbookvalue is non zero.

Am I using the right type of query to accomplish my goal??

Thanks