how to combine repeated values?

[mmaglio]

Ive used a query to make a table which shows the data I want, (specifically, which vendors carry which products) but it repeats the same pairs of values many times (when a vendor carries the same product from many manufacturers).

Anyone know how to format the resulting table to just disregard repetitions? Or any other method for getting rid of this?

Thanks to all.

 

[JeremyNYC]

Check out the help files for totals queries.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.