problem with min max inside crosstab

mikarsen

Registered User.
Local time
Today, 08:37
Joined
Sep 12, 2006
Messages
17
here's my problem...
i have a crosstab query where in one field (value) has a range of 1 to 19.
I used the min and max for two separate row headings....

the min and max works only on values (1 to 9) or (11 to 19)
example... the 2 columns have values 8 and 4
the min returns 4 and the max returns 8

however, when the values became a mix of single and double digit (e.g. 11 and 8)
the min returns 11 and the max returns 8

does the min function on compares the values with only the same digits?

pls help.
 
It looks to me as if the field that holds the value is actually text. If it is text them 11 is the minimum and 8 the maximum.
 
yup the field that contains the value in the main table is a 'text' type. however I converted it to a number using the column properties in crosstab... but i still get the same results...
 
The cross tab happens after the Min/Max is applied. You could use a calculated field using CInt() to convert the text to numbers.
 

Users who are viewing this thread

Back
Top Bottom