How do I format numbers in an Access report?

[BNIRPC]

I need to include numbers in a report with fixed format, and four decimal
places. The report puts the numbers in scientific notation, even after
setting the format on the controls.

 

[Duane Hookom]

Make the text box a little wider.

 

[BNIRPC]

That didn't help. I also tried going back to the query that generated the
report and could not specify fixed format. The query results just give me
scientific notation.

 

[BNIRPC]

The query uses the Nz([...],0) function to force zeros in otherwise null
fields. The result is a text field not a number. How do I get the query to
do this and return fixed (4 decimal places) numbers?

 

[Duane Hookom]

Use Val(Nz([...],0)) in your query.

--
Duane Hookom
MS Access MVP
--

The query uses the Nz([...],0) function to force zeros in otherwise null
fields. The result is a text field not a number. How do I get the query
to
do this and return fixed (4 decimal places) numbers?

That didn't help. I also tried going back to the query that generated
the
report and could not specify fixed format. The query results just give
me
scientific notation.

 

[BNIRPC]

Thanks, that worked.

Use Val(Nz([...],0)) in your query.

--
Duane Hookom
MS Access MVP
--

The query uses the Nz([...],0) function to force zeros in otherwise null
fields. The result is a text field not a number. How do I get the query
to
do this and return fixed (4 decimal places) numbers?

That didn't help. I also tried going back to the query that generated
the
report and could not specify fixed format. The query results just give
me
scientific notation.

:

Make the text box a little wider.

--
Duane Hookom
MS Access MVP
--

I need to include numbers in a report with fixed format, and four
decimal
places. The report puts the numbers in scientific notation, even
after
setting the format on the controls.