Adding Dates and getting an empty screen 1

[drussum]

I have a qry that is summing months to come up with a quarterly summary example: 1st Quarter Total Actual: Sum([qryRectActBud1].[T$AMNT$1]+[qryRectActBud1].[T$AMNT$2]+[qryRectActBud1].[T$AMNT$3])

This qry was working last year when we had a full year of data. Now that this is Feb I am getting mostly blank screens. Why is this?? any ideas would be greatly appreciated. Thanks.

 

[MichaelRed]

Guessing.

Some / Many elements are NULL, so results are NULL, use Nz to use ZERO in place of NULL.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[drussum]

Hello Michael, What would the syntax look like?

(NZ)...... 1st Quarter Total Actual: Sum([qryRectActBud1].[T$AMNT$1]+[qryRectActBud1].[T$AMNT$2]+[qryRectActBud1].[T$AMNT$3])

 

[MichaelRed]

Nz([qryRectActBud1].[T$AMNT$1])

or, more generally -

Nz(expression)

Returns 0 if the expression is null, otherwize retutrns the expression

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[MichaelRed]

Nz([qryRectActBud1].[T$AMNT$1])

or, more generally -

Nz(expression)

Returns 0 if the expression is null, otherwize retutrns the expression. All documented in the HELP system.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over