[AccessD] Format for decimal

Hi Barbara

> I am displaying several "hours worked" fields on a report (which contains 2 decimal positions).  If hours worked is a whole number, I do NOT want to display any decimal positions (e.g. "8"); if
> hours worked is 0, I do not want to display anything (i.e., leave the field blank/null); it hours worked contains decimals, I want to display the decimals (e.g., "8.25").

> If I set up the format as "##.##", the decimal point is displayed when hours worked is a whole number (e.g., "8.")  How do I get rid of that pesky decimal point??

If you only have positive counts you can cheat and adjust your source
as this:

  =IIf(Int([HWorked])=[HWorked];[HWorked];-[HWorked])

which will display a negative count for decimal hours.

Now, adjust your format string to this:

  0;0.00;""

which will leave blanks for zero hours count.

/gustav