| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 21152 | 2002-06-18 22:20:00 | Rounding calculated contol results in Access | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 55086 | 2002-06-18 22:20:00 | Attempting to create a small payroll database I have only one small but very annoying problem.The paymaster pays staff to the minute, thus the hour rate must be divided by 60 then multiplied by the number of minutes. All is fine except where the answer is in excess of 2 decimal places. Whilst I can get it to display to two decimals, further calculations involving this figure result in, usually, an increase of 1c in the answer.Does anybody have a quick fix to this please as there does not appear to be a rounding function in Access. I am running Access 97 on Win 98. | Guest (0) | ||
| 55087 | 2002-06-19 01:46:00 | Have not used Access but a similar problem can occur in Excel. In that prog it is overcome by going to a Calculations tab (I think it is in Tools, Options) and putting a check mark against Calculate as Displayed. This forces Excel to use the (rounded) displayed values in subsequent calculations instead of the underlying unrounded values. I suspect there will be an equivalent setting in Access. | Guest (0) | ||
| 55088 | 2002-06-19 08:18:00 | Thanks for the prompt reply Robin but the problem is deeper than that. Regards Roy. | Guest (0) | ||
| 1 | |||||