Case Sensitive Cross Tab Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I create a case sensitive cross tab query? I am using Access 2000.

One of the fields that is grouped by rows has a mixture of lower and upper
case entries and I want the query to differentiate between these
 
I'm not 100% sure that you can!

You might try writing a function that converts the string into its Hex
representation, and group on that (while displaying the non-hex version).
 
Back
Top