Expression help

[KYJVKG via AccessMonster.com]

I have a table that shows all orders placed by the company.

I would like to create a query to only show products purchased from multiple
vendors.

my fields are vendor name and line description.

can someone help me with an expression that will allow me to do this?

 

[Jerry Whittle]

SELECT [line description], Count([vendor name]) as NumVendors
FROM [YourTable]
GROUP BY [line description]
HAVING Count([vendor name]) > 1
ORDER BY [line description] ;