Case Sensitive Data

[VLPOTTER]

I am playing around with polygenic genotypes that are cae sensitive, for example: AABBCCDD, AaBbCcDd, AAbbCCdd, etc. Each distinct genotype will have different manifestations for the carriers of those genotypes. I wanted to get the unique set of the data by grouping them in a query, but Access does not take the case sensitivity of the data into account. Is there a way to do this in Access?

[June7]

Use a function that converts strings to hex and group on the hex value. Review https://support.microsoft.com/en-us/...rs=en-us&ad=us
Here's the function in case the link dies:

Function StrToHex (S As Variant) As Variant
'
' Converts a string to a series of hexadecimal digits.
' For example, StrToHex(Chr(9) & "A~") returns 09417E.
'
   Dim Temp As String, I As Integer
      If VarType(S) <> 8 Then
         StrToHex = S
      Else
         Temp = ""
      For I = 1 To Len(S)
         Temp = Temp & Format(Hex(Asc(Mid(S, I, 1))), "00")
      Next I
         StrToHex = Temp
      End If
End Function