Hi Guys
Hope you can help.
I will gve you an example of what I am doing. I attended an appointment on 01/12/2008. The report picks out the company which I had appointment with and if any ales havebeen made so will look like ths.
(Userid) - (Company) - (Contact) - (Sale Date)
The sale date shows if their was a sale made against that contact. What I need I to do is if their is no sale against ths specific contact, scan through the database and look at any sales made for another contct with the same company name and insert the date in here.
Hope this makes sense
Hope you can help.
I will gve you an example of what I am doing. I attended an appointment on 01/12/2008. The report picks out the company which I had appointment with and if any ales havebeen made so will look like ths.
(Userid) - (Company) - (Contact) - (Sale Date)
The sale date shows if their was a sale made against that contact. What I need I to do is if their is no sale against ths specific contact, scan through the database and look at any sales made for another contct with the same company name and insert the date in here.
Hope this makes sense