I see that Micron and June have posted since my original post. He may have other thoughts and ideas.
I agree better to use a query as the basis for your report's recordsource.
If you have any sorting to do, it should be done within the report. Reports have their own sorting and grouping facility.
Here is another test routine to exercise the function for values 1 ---63. It may help in understanding the workings of the function and vba.
Code:
Sub testCN()
Dim i As Integer
Debug.Print " List LCD fractions (in /64ths) where numerator has values 1 to 63 "
For i = 1 To 63
Debug.Print " LCD fraction : " & LCD_strFrac(i) 'calling the function with the value of i
Next i
End Sub
Result:
Code:
List LCD fractions (in /64ths) where numerator has values 1 to 63
LCD fraction : 1/64
LCD fraction : 1/32
LCD fraction : 3/64
LCD fraction : 1/16
LCD fraction : 5/64
LCD fraction : 3/32
LCD fraction : 7/64
LCD fraction : 1/8
LCD fraction : 9/64
LCD fraction : 5/32
LCD fraction : 11/64
LCD fraction : 3/16
LCD fraction : 13/64
LCD fraction : 7/32
LCD fraction : 15/64
LCD fraction : 1/4
LCD fraction : 17/64
LCD fraction : 9/32
LCD fraction : 19/64
LCD fraction : 5/16
LCD fraction : 21/64
LCD fraction : 11/32
LCD fraction : 23/64
LCD fraction : 3/8
LCD fraction : 25/64
LCD fraction : 13/32
LCD fraction : 27/64
LCD fraction : 7/16
LCD fraction : 29/64
LCD fraction : 15/32
LCD fraction : 31/64
LCD fraction : 1/2
LCD fraction : 33/64
LCD fraction : 17/32
LCD fraction : 35/64
LCD fraction : 9/16
LCD fraction : 37/64
LCD fraction : 19/32
LCD fraction : 39/64
LCD fraction : 5/8
LCD fraction : 41/64
LCD fraction : 21/32
LCD fraction : 43/64
LCD fraction : 11/16
LCD fraction : 45/64
LCD fraction : 23/32
LCD fraction : 47/64
LCD fraction : 3/4
LCD fraction : 49/64
LCD fraction : 25/32
LCD fraction : 51/64
LCD fraction : 13/16
LCD fraction : 53/64
LCD fraction : 27/32
LCD fraction : 55/64
LCD fraction : 7/8
LCD fraction : 57/64
LCD fraction : 29/32
LCD fraction : 59/64
LCD fraction : 15/16
LCD fraction : 61/64
LCD fraction : 31/32
LCD fraction : 63/64