NZ changing format? 1

[straybullet]

CPCompCt: Count([ConstructionDateCompleted])

results in 29, right aligned in the cell

CPCompCt: nz(Count([ConstructionDateCompleted]),0)

results in 29 as well, however it's now left aligned in the cell.

is this indicating the result is now being treated as text?

Let them hate - so long as they fear... Lucius Accius

 

[PHV]

Why using the Nz function with the Count aggregate function which should never returns a Null value ?

Anyway, to be sure to get a numeric value with the Nz function:
Val(Nz(Expression,0))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[straybullet]

Thank you - there are times the value could be null, just trying to be ready for it.

Let them hate - so long as they fear... Lucius Accius