How do I format numbers in an Access report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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?
 
Use Val(Nz([...],0)) in your query.

--
Duane Hookom
MS Access MVP
--

BNIRPC said:
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?

BNIRPC said:
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.
Click to expand...
Click to expand...
 
Thanks, that worked.

Duane Hookom said:
Use Val(Nz([...],0)) in your query.

--
Duane Hookom
MS Access MVP
--

BNIRPC said:
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?

BNIRPC said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top