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

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" <(E-Mail Removed)> wrote in message
news:4E732025-A4D8-47E0-B8C2-(E-Mail Removed)...
>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

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 [MVP]" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:4E732025-A4D8-47E0-B8C2-(E-Mail Removed)...
> >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
>
>
>

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 [MVP]" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:4E732025-A4D8-47E0-B8C2-(E-Mail Removed)...
> >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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:A6ED61E9-BE7D-4A63-BB31-(E-Mail Removed)...
> 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 [MVP]" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:4E732025-A4D8-47E0-B8C2-(E-Mail Removed)...
>> >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
>>
>>
>>

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 [MVP]" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:A6ED61E9-BE7D-4A63-BB31-(E-Mail Removed)...
> > 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 [MVP]" wrote:
> >
> >> 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" <(E-Mail Removed)> wrote in message
> >> news:4E732025-A4D8-47E0-B8C2-(E-Mail Removed)...
> >> >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
> >>
> >>
> >>
>
>
>