What I need to to is look into each row and find out the lowest number and place the column name into another field. If the lowest number has 1 or 2 values then have both column names in the OptimalOrigin field. I have 42,000 different zipcode.
You are the Access Monkey I understand what you are saying to place the destorigin in fifferent tables but that does not tell me anything I am in need of help with a formula to find the lowest number in a row. Can you help me out?
Well, THEN I could help you fairly easily. If you keep the syntax the way it is, well now you have a very, VERY big problem on your hands... You will have to find a way to iterate through each field and compare it to every other field, not a simple task. In contrast, if you change your format, it would be as simple as:
SELECT origin, rank
WHERE rank= Min(rank)
GROUP BY zip_code