Cross-Post from Reports - Decimal Formatting


G

Guest

I had this question earlier today. 2 MVPs I highly respect and
I tried to solve this, but it's ornery...

I have this calculation..
=Round([Text148]/([Text147]/60),2)
...in a Group Footer.

If the calc is 62.00, it displays as as 62...if it's 57.50, it displays
as 57.5. All other values are rounded to 2 decimal places...
I'm Formatting as Fixed, 2 decimal places. Even tried Standard,
2 decimal place and "Auto" decimal places.

Hoping someone here has the solution...if only we could do like
Excel's - "Format - Cells - Number - 2 Decimal places"...that always
seems to work.

TIA - Bob
 
Ad

Advertisements

A

Arvin Meyer [MVP]

I've never had a problem like that. It should respect Fixed and 2 Decimal
places. However, you can try wrapping the expression in the Format function:

=Format(Round([Text148]/([Text147]/60),2),"Fixed")
 
G

Guest

Arvin - Thank you.

I tried, again..
Format(Round([Text148]/([Text147]/60),2),"Fixed")
...and Properties of... Format = Fixed ... and Decimal Places = 2.

Still 62.00 appears as 62.

I answered Marsh Barton in "Reports"...maybe it's the latest Windows 2000
Security Update 2 weeks ago...running Access 2003??? Far-fetched I agree...

May just be "one of those things."

Thank you - Bob

Arvin Meyer said:
I've never had a problem like that. It should respect Fixed and 2 Decimal
places. However, you can try wrapping the expression in the Format function:

=Format(Round([Text148]/([Text147]/60),2),"Fixed")
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Bob Barnes said:
I had this question earlier today. 2 MVPs I highly respect and
I tried to solve this, but it's ornery...

I have this calculation..
=Round([Text148]/([Text147]/60),2)
..in a Group Footer.

If the calc is 62.00, it displays as as 62...if it's 57.50, it displays
as 57.5. All other values are rounded to 2 decimal places...
I'm Formatting as Fixed, 2 decimal places. Even tried Standard,
2 decimal place and "Auto" decimal places.

Hoping someone here has the solution...if only we could do like
Excel's - "Format - Cells - Number - 2 Decimal places"...that always
seems to work.

TIA - Bob
 
G

Guest

Far-fetched guess - I need the Text148 and Text147 displayed like...
Both have Properties of Format Standard and Decimal Places = 0.

Can you see any reason those properies "might" affect the Fixed 0??
Guess I could try a bunch of Property modifications, but the Standard 0
is what I need.

Thank you - Bob



Arvin Meyer said:
I've never had a problem like that. It should respect Fixed and 2 Decimal
places. However, you can try wrapping the expression in the Format function:

=Format(Round([Text148]/([Text147]/60),2),"Fixed")
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Bob Barnes said:
I had this question earlier today. 2 MVPs I highly respect and
I tried to solve this, but it's ornery...

I have this calculation..
=Round([Text148]/([Text147]/60),2)
..in a Group Footer.

If the calc is 62.00, it displays as as 62...if it's 57.50, it displays
as 57.5. All other values are rounded to 2 decimal places...
I'm Formatting as Fixed, 2 decimal places. Even tried Standard,
2 decimal place and "Auto" decimal places.

Hoping someone here has the solution...if only we could do like
Excel's - "Format - Cells - Number - 2 Decimal places"...that always
seems to work.

TIA - Bob
 
A

Arvin Meyer [MVP]

It may be something outside. If you open the Debug (Immediate) window and
enter:

? Round((12.225/6)/60,2)

The answer comes up:

0.03

If you run it in a query, same answer. If you run it as the controlsource of
a textbox:

=Round((12.225/6)/60,2)

without even setting a format and letting it auto set the decimal places, it
still comes out as 0.03

I've tried it in Access 97 (with a different Round function) Access 2002,
and Access 2003. Still 0.03

All I can suggest is to set all contributing the textboxes to: Fixed, 2
places.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Bob Barnes said:
Arvin - Thank you.

I tried, again..
Format(Round([Text148]/([Text147]/60),2),"Fixed")
..and Properties of... Format = Fixed ... and Decimal Places = 2.

Still 62.00 appears as 62.

I answered Marsh Barton in "Reports"...maybe it's the latest Windows 2000
Security Update 2 weeks ago...running Access 2003??? Far-fetched I
agree...

May just be "one of those things."

Thank you - Bob

Arvin Meyer said:
I've never had a problem like that. It should respect Fixed and 2 Decimal
places. However, you can try wrapping the expression in the Format
function:

=Format(Round([Text148]/([Text147]/60),2),"Fixed")
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Bob Barnes said:
I had this question earlier today. 2 MVPs I highly respect and
I tried to solve this, but it's ornery...

I have this calculation..
=Round([Text148]/([Text147]/60),2)
..in a Group Footer.

If the calc is 62.00, it displays as as 62...if it's 57.50, it displays
as 57.5. All other values are rounded to 2 decimal places...
I'm Formatting as Fixed, 2 decimal places. Even tried Standard,
2 decimal place and "Auto" decimal places.

Hoping someone here has the solution...if only we could do like
Excel's - "Format - Cells - Number - 2 Decimal places"...that always
seems to work.

TIA - Bob
 
Ad

Advertisements

G

Guest

Me - not so smart...I hadn't set the Fixed 2 in the Detail Textbox...In
Design View,
I had Fixed 2 ONLY on the Group Footer.

Thank all of you (in "Reports" also)..

Bob

Arvin Meyer said:
It may be something outside. If you open the Debug (Immediate) window and
enter:

? Round((12.225/6)/60,2)

The answer comes up:

0.03

If you run it in a query, same answer. If you run it as the controlsource of
a textbox:

=Round((12.225/6)/60,2)

without even setting a format and letting it auto set the decimal places, it
still comes out as 0.03

I've tried it in Access 97 (with a different Round function) Access 2002,
and Access 2003. Still 0.03

All I can suggest is to set all contributing the textboxes to: Fixed, 2
places.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Bob Barnes said:
Arvin - Thank you.

I tried, again..
Format(Round([Text148]/([Text147]/60),2),"Fixed")
..and Properties of... Format = Fixed ... and Decimal Places = 2.

Still 62.00 appears as 62.

I answered Marsh Barton in "Reports"...maybe it's the latest Windows 2000
Security Update 2 weeks ago...running Access 2003??? Far-fetched I
agree...

May just be "one of those things."

Thank you - Bob

Arvin Meyer said:
I've never had a problem like that. It should respect Fixed and 2 Decimal
places. However, you can try wrapping the expression in the Format
function:

=Format(Round([Text148]/([Text147]/60),2),"Fixed")
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


I had this question earlier today. 2 MVPs I highly respect and
I tried to solve this, but it's ornery...

I have this calculation..
=Round([Text148]/([Text147]/60),2)
..in a Group Footer.

If the calc is 62.00, it displays as as 62...if it's 57.50, it displays
as 57.5. All other values are rounded to 2 decimal places...
I'm Formatting as Fixed, 2 decimal places. Even tried Standard,
2 decimal place and "Auto" decimal places.

Hoping someone here has the solution...if only we could do like
Excel's - "Format - Cells - Number - 2 Decimal places"...that always
seems to work.

TIA - Bob
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top