Case Sensitive Cross Tab Query

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
 
D

Douglas J. Steele

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Case sensitive joins 5
Case sensitive query 19
Ordering of Cross Tab Query 7
case-sensitive primary keys 10
Memo field in cross tab query 2
Need Help with a Case-Sensitive 'Like' Query 4
Cross Tab Quert Totals 4
Basing a report on an updated cross-tab query 2

Top