Record Count Format

[Guest]

Hi There,

I am doing a record count in one of my queries:
"CountOfRECORD TYPE"
It result needs to be right justified and 9 numeric characters, in the
format "000000000".
Please can someone tell me the right calculation to use, as I have tried
different
ways and am not getting the right result.

Thanks so much.

 

[fredg]

Hi There,

I am doing a record count in one of my queries:
"CountOfRECORD TYPE"
It result needs to be right justified and 9 numeric characters, in the
format "000000000".
Please can someone tell me the right calculation to use, as I have tried
different
ways and am not getting the right result.

Thanks so much.

Exp:Format(Count([SomeField]),"000000000")

If this is a Total (Group By) query, set the Total row to Expression
for this column.