F
F
favbet2015-07-08 22:47:54
Microsoft Access
favbet, 2015-07-08 22:47:54

How to avoid losing pennies in calculated access fields?

I import data from Excel to Access and carry out calculations in the request. At the same time, pennies are lost on each amount in the accessory.
Please tell me how can this be avoided?
Access field type: Numeric floating point. In theory, there should be no loss.
For example: 25/100000.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Maxim Moseychuk, 2015-07-08
@fshp

There is a special data type for currencies - Currency

F
favbet, 2015-07-08
@favbet

These are not currencies, but volume indicators.
Table field type on the server: Double floating point and I have no rights to change it.
How to get around this problem?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question