Can i group fields that are alike. I have a huge database of vendors from accross the U.S, who show up on my datbase as various entiries for reporting purposes i would like to see them in single purchase . For example have ten Best Buys ( TV & Appliance Store ) who have each a unique location. I don't care where it is located i just want one number for all items related to this vendor.

Thanks in Advance

Serg