Hi there
Have a DB that records Business Opportunities and deals. Each opportunity can lead to several deals but at present there is only a deal ID and no Opportunity ID exists.
Need to ID number of Opportunities in TblDealData.
An opportunity would have the same: CustID, Start_Date, End_Date, Deal_Size_Min, Deal_Size_Max
But Diff Trade_IDs
Have tried a select query and group by each of the above and finanly got a Count on Deal_Size_Max but figs not correct
Any ideas?
Thanks