>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

Select * From table1 Group by VendorName && use real table/field names