Decimal Places not working

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

Guest

Hi,

I have a report that has some numbers and calculations on it.

The original table is a linked table from excel.
The calculations of the affected fields in excel are:
=77+K120-20*(LOG(OffAir!P120))
=S121-T121-U121
=20*LOG(39.5/E122)
=V117+W117-X117+Y117
=Z115+AA115

These are the fields that show up in my access report as many decimals. I
have tried changing all formatting to 1 decimal but it still shows up with
about 6 or more.

Is there a way I can fix this so that my report is only showing the
calculations with 1 decimal? They show up correctly in excel and in my
access table but not on the report.
 
Are the fields left or right aligned when viewed in datasheet? Did you set
the format property to "Standard"?
 
They are right aligned. I couldn't find '"Standard" format but I changed it
to "Fixed" and that works fine.

Thanks
 
Back
Top