Never mind. Access screwed me. I only had to change the ORDER BY clause to the original numneric field instead of what Access supplied which was Format([Numeric_Field], "currency"). Sometimes the "helpful" automatic things Access does are a real pain!