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