A table with a calculated field with field properties as follows:
Expression UnitRev-MF1-MF2-Mf3
Result type
A table with a calculated field with field properties as follows:
Expression UnitRev-MF1-MF2-Mf3
Result type
What is the formatting problem?
Is UnitRev-MF1-MF2-Mf3 a field name or attempting arithmetic?
What is "Result type"?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
select the report's textbox , set the format property.
Result Type Double
Format Standard
Decimal Places 2
Text Align General
The calculation works properly and nis displayed in Data Sheet View as 1,688.60.
When putting that field in a text box in a report it appears as 1688.6.
I have tried changing the Result type but nothing I have changed will display in the report as it is in the table.
There has to be some simple thing I'm missing.
Any Thoughts
Thanks
Thanks Ranman I should have known that