Microsoft Access should allow usage of summation or multiplicatio.

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

Guest

There is no format for fractional number and its formula, eg. 2/8 + 5/9 in
microsoft access. But it exist in microsoft excel!. I cannot sum fractional
number in access's form and the result is #error

I hope Microsoft could quickly add this feature as soon as possible.

Thank You.
 
You can manipulate fractional numbers in Access, but it's NOT a spreadsheet
(which is much more powerful when crunching numbers)

Are you storing the calculation in a table? If so, what Datatype is the
field you're storing this value in? If you're dealing in fractions, try
changing it to a Double or Single numeric type to store the result properly.
Anything else and you'll get the #ERROR indication. And remember to use
proper grouping:

((7/8) + (5/9)) * 3
 
Back
Top