Sum of field not retrieving 0 value when needed

[andrebmsilva]

Hi,

I have a log. I analize it via queries. I want to sum the field Expr2 , but sometimes there are no events. I wish when that happens the value would be 0.
Any sugestions?

I have tried:
Nz(Sum([Soma 3 from Completed Turno A].Expr2),0)
Sum(Nz([Soma 3 from Completed Turno A].Expr2),0)



None have worked... what am i missing?


THanks

[Bob Fitz]

Can you post a copy of the db in A2003 mdb format.

[andrebmsilva]

Can you post a copy of the db in A2003 mdb format.

Here it is

Dúvida Zero.mdb

[Bob Fitz]

I want to sum the field Expr2

In which query.

I have tried:
Nz(Sum([Soma 3 from Completed Turno A].Expr2),0)
Sum(Nz([Soma 3 from Completed Turno A].Expr2),0)

Where have you tried these expressions

[andrebmsilva]

In "Soma 3 from Completed Resultado TA"

[Bob Fitz]

I'm a bit confused. The query called "Soma 3 from Completed Resultado TA" returns a value of 74. So what's the problem.

[andrebmsilva]

This is what i see... a null field... what is happening?

[June7]

Don't know. I also see 74.

[Perceptus]

I see 74 also.

[orange]

I also see 74.