Using Access 2000,
I am creating a report that get info from a Query (QryOneContractFundDocs
) whose statement is as shown below:

SELECT FundingDocs.FundingDocTitle, FundingDocs.DollarAmount, FundingDocs.ContractNumber
FROM FundingDocs
WHERE (((FundingDocs.ContractNumber)='NMIPR029209245 DD448-2'));

That report has “dollar amount” as one the columns and get info from

[FundingDocs].[DollarAmount]

as well as a summary which is as shown below and is put in the control’s control source;

=IIf(IsNull(Sum([FundingDocs].[DollarAmount])),0, NZ(Sum([FundingDocs].[DollarAmount])))


When there is no entty at all (when the query is empty, I get

“#Error”

in the summary control.

Can some help me find a way of getting a zero instead.

Wango