According to Sage 100, it is not a duplicate, since Division is part of the primary key for vendors.  If you want this done I expect you'll need to use a tool other than VI (which is comparatively limited when it comes to exports).

Yeah, I figured as much.  Just wanted to confirm with the group.  Thank you for your response, Kevin.

Your best option would be to link the table you want data in an Access database then create a make table query and use the Group function to get only a single row for each Vendor. Or you could write a Crystal Report

The big issue with any consolidation is you need to handle the multiple records.  Which version of each field is returned... because each could technically have a different name / address... ?

That is true Kevin but based on his question I am guessing all the Vendors have the same information hence the desire to have only one record per Vendor

BigLouie is correct, Kevin...the data for the vendors are the same except for the Division.  There my be times where one vendor in a Division doesn't appear in any of the other divisions but that will be rare.

Agreed, but I've been burned by such assumptions enough times that I always remember to explicitly handle such things.  Safer that way.

If you do the Access thing and group on the Customer Number and leave out the division you will be fine

Thank you, BigLouie.