I have a table with a column of 12 values: 1.01 to 1.12
the column can be set to either Decimal or Double, with an Input Mask setting the field to = #.##
no matter what value I put in.
However when I retrieve the value via some VBA Code 1.10 turns to 1.1. I desperatly need it to stay as 1.10 like wise if the value = 1.20 I want it to stay at 1.20.
I could create a string however you can't sort a string if the values are numbers in a table.
Upon creating the table and inputting the values, I then run the following Code (Code Section).
Can I ask one of you experts please help me to retain the leading zero of numbers such as 1.10 and KEEP it as a number when runnning it through the code below.
Option Compare Database
Public Sub testing()
Dim db As Database
Dim Rst As Recordset
Dim Sql As String
Set db = CurrentDb
Sql = "Select Numbers from table1 order by Numbers asc;"
Set Rst = db.OpenRecordset(Sql, dbOpenSnapshot)
Do Until Rst.EOF