Running Queries

[bjm027]

I am also trying to run a query where I am pulling Company_Name from tblCompany_Information and also Contact_Number from tblContact_Information. Now, one company can have multiple contacts which when the query is ran, say the company has three different contacts associated with it, the company will appear three different times. Any help/suggestions?

 

[randysmid]

Hi,
You can use the DISTINCT keyword inside the query. I wrote an FAQ on this topic. My FAQ also covers the keyword DISTINCTROW, which may be useful to you in the future.
faq701-3274 HTH,
Randy Smith
California Teachers Association