Hi everyone,
The query that is causing me trouble (posted below) is based on several other queries.
Code:
SELECT Region, MIN(RoadLengthPerM2) as BestRL, MAX(RoadLengthPerM2) as worstRL, MIN(pctAG) as BestPctAG, MAX(pctAG) as WorstPctAG, MIN(pctDEV) as BestPctDEV, MAX(PctDEV) as WorstPctDEV, MIN(PctStreamsAltered) as BestASL, MAX(PctStreamsAltered) as WorstPctASL
FROM qry_RatioAttributes
GROUP BY Region
Running this query gives me an "overflow" error. Apparently this is because I am trying to fit a value into an incorrect field type, but I have no idea what the field type resulting from a query is.
qry_RatioAttributes gets all of the values used in the above query from double fields calculated as percentages of one another, and rounded to 3 decimal places.
Any insight will be appreciated, could it be this rounding of numbers that is causing trouble?