Literal Columnheaders in crosstable query

  • Thread starter Thread starter FA
  • Start date Start date
F

FA

Hello,


In Access97 I need to make a crosstable query where the columnheadings
are A1, A2, A3, a1, a2, a3 which are field-values that are entered
capssensitive. A1 <> a1 etc.
In the properties of the crosstablequery at the columnheader I specify
alle the needed columnheadings in a ';' seperated listing.

It seems that Access does not differentiate for a columnfield between
A1 and a1. It tells me that A1 can only be used once as a columnfield.

How can I force Access to take the input of the vield exact as entered
by user ?
 
You would be looking for fudges such as VBA calls that detect the
case-sensitive difference, and substitute some other value so the query
engine can tell the difference. StrComp() and Replace() might be useful.
 

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

Problem with displaying query as a 2D grid 10
Access Query criteria based on other field of the same query 0
Access 2000 Query very slow compared to SQL Query Analyzer 5
Parameter Query 1
Adding values in to table for appropriate fields only 5
distance range crosstable 3
crosstab query parameter error 12
recursive relationship query question 8

Back
Top