Single Value Return in Query Populating Listbox (1 Viewer)

[DMerchen]

I am doing a query to populate a listbox from a separate table. When I do the query, I receive multiple returned values, and multiple values that are the same. Can I limit the number of returned values to be a list of the values in the table I am pulling from?

Vendor Table- -Only 2 entries. Should only show 2 values in List box if set up correctly...in my opinion.

Results when pulling the List box on the separate table.

The SQL Statement
SELECT Vendor.[Vendor Name], [Vendor].[Vendor Name] & "-" & [US/Non-US] AS Name FROM Projects, Vendor ORDER BY Vendor.[Vendor Name], [Vendor].[Vendor Name] & "-" & [US/Non-US];

Any help is appreciated.

Thanks,
Dave

 

[theDBguy]

Try removing the Projects table from your query.

 

[DMerchen]

Okay!! Too easy! Thanks for seeing that. Sometimes I can look at something too long.

Thanks for the assist! Works perfect!

Dave

 

[theDBguy]

Okay!! Too easy! Thanks for seeing that. Sometimes I can look at something too long.

Thanks for the assist! Works perfect!

Dave

Glad to hear you got it sorted out. Good luck with your project.