ct_crosstab1.zipOn May 9th I posted a query to arrange the location. June7 solved it , and it worked fine until now. But I have values A8, A9, A10, A12, A13 in my tables which is causing sorting issues because when there is 8,9,10. it's taking 10 as the min value and 9 as max value. and not showing 8 at all.
I google to find a solution and some said to have the fields as Integer but that did not work.
any other suggestions to resolve the sort issue?
Thank you in advance.
TRANSFORM Max(Wells.Cnum) AS MaxOfCnum
SELECT Left([Well],1) AS WellGrp, Min(Mid([well],2)) AS WellMin, Max(Mid([well],2)) AS WellMax, Wells.well_sort
FROM Wells
GROUP BY Left([Well],1), Wells.well_sort
PIVOT Wells.rank;