A student using MS Access 2016 made a table of celestial bodies that included their mass in Kg. The sun for example is 1.989E+30Kg (or 1989000000000000000000000000000Kg in standard notation). She used a datatype of Short Text.
I would like to help this student convert that to a number so she can (for example) select out the largest 10% of celestial bodies by mass. The new Large Number data type appears to hold only a max value of 2^63 (9.223372e+18 or 9223372000000000000 in standard notation)
.
Does Access have anything equivalent to the SQL
Code:
DECLARE @solarMass DECIMAL(35,0) = 1989000000000000000000000000000;
If not, what do you do when needing to handle large numbers in Access?
Thanks.