joeyz,
I used my randomNumber function and ran it several times with this code as a test.
Code:
Sub tR()
'using a random number to identify Male vs Female
'where an even number is used to increment Male count, and
' an odd number is used to increment Female count.
Dim i As Long, M As Long, F As Long
For i = 1 To 1000
If (randomNumber(1, 10000) Mod 2 = 0) Then 'even or odd
M = M + 1
Else
F = F + 1
End If
Next i
Debug.Print M & " " & F
End Sub
and got these results for M vs F randomness
Code:
496 504
493 507
491 509
501 499
501 499
496 504
496 504
507 493
501 499
I agree that using attachment or multi-valued fields is not something to be encouraged. There are established procedures/methods to achieve the same functionality, but M$oft implanted them into Access for some reason.
Many think it was to attract/appease new users?? Most feel they contravene sound principles.
I don't use them, but some people do and post with related concerns. I have responded to a few more from interest and assistance rather than encouraging their use.