Record Count Format

L

Lucy

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.
 
F

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.
Click to expand...

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

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