April 26, 2012 at 9:26 am
I have a query result with company names,names,addresses,emails and a list of services (but listed as ,1,4,26,10 etc.) and a table with the services on separate rows and the English Description(s) as well as the numbers again.
The first results can have more than two company names, but with different personal names, and when I try to join the table that has the description, so I can see which company has chosen which services then the query results multiply up manuy times.
What I want to achieve is the full list of company names and personal contacts with the english description of the services that the COMPANY has chosen.
Any ideas?
evnt_CompanyId/Comp_Name/evnt_EventsID/evnt_Name/evnt_Venue/evnt_show_open/Pers_FirstName/Pers_LastName/epd_EmailAddress/evnt_AppointedServices
evsv_eventsservicesidevsv_CreatedByevsv_CreatedDateevsv_UpdatedByevsv_UpdatedDateevsv_TimeStampevsv_Deletedevsv_emailsentevsv_eventsidevsv_primarybudgetevsv_primaryprofitevsv_revisedbudgetevsv_revisedprofitevsv_serv_servicesidevsv_servicecodeevsv_servicecompetitorevsv_servicecontactevsv_servicedistributionevsv_servicenameevsv_servicestatus
April 26, 2012 at 9:30 am
Please take a look at the article in my signature by Jeff Moden to help us help you better.
Jared
CE - Microsoft
April 26, 2012 at 9:34 am
Not from what you have posted. Not really sure what you are asking or trying to accomplish.
You may benefit from reading the first article I reference below in my signature block. It will show you what you need to post and how to get the best possible answers to your questions.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply