Limit number of results

[choolan01]

I am designing a database for a marketing company. One of my tables has all of the company's contacts. On the contacts form, I have a button that opens up a query that shows the information for the company that contact works for. I have a problem where if I have more than one contact per company, it will return that many results (which is just a repeated list of the same company information). It is an eyesore to look at the same information in two or more rows, so I was wondering, can I make the query return only one result? I've been looking online, and I haven't found this at all. Thanks a lot.

 

[KeithIT]

Sounds like you have set up your query in a way that looks through the records too many times. Can you post the set up of your query (show us what fields you are pulling from what tables and with what parameters).