Group, I have hopefully a solvable question. Per blockgroup for the u.s., i have 12 variables of household data. What I want to do is, whatever variable has the highest household count, I need a 13th variable to enter in the number of the variable that the highest household came from. Can this be done in MapInfo or Microsoft Access? Here is an example what I need done. BG 1 2 3 4..............................13 010010020867 208 330 5 10 2 thanks for any help -------------------------------------------------------------------- Philip Lesnik Research Systems Analyst, Market Research General Growth Properties, Inc. 110 N. Wacker Drive BSC 3-13 Chicago, IL 60606 312-960-2998 312-960-5519 (fax) [EMAIL PROTECTED] -------------------------------------------------------------------- ----------------------------------------- +++++++++++++++++++++++++++++++++++++++++++++++++++++++ Notice: This e-mail including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. §§ 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. +++++++++++++++++++++++++++++++++++++++++++++++++++++++ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15706