Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi all,
I have loaded a table which is a transaction table showing the sales by Product,Year,Month ..etc
I have taken two list box ProductID, Year and a text box Year,
I just want to display the years associated with the ProductId when a product is selected, so far that I have used Concat function in the
text box and later got a thought to sort the displayed years in the ext box in descending order but to my strange I am getting the years
twice in the text box.
Please advice what might me wrong.
Iam attaching my sample
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		=' The values selected in year field are' &chr(13)&
Concat(DISTINCT Year,CHR(10),-Aggr(NODISTINCT SUM(Sales),Year))
or
=' The values selected in year field are' &chr(13)&
Concat(DISTINCT Year ,chr(13),-Aggr(NoDistinct Sum(Sales),[Product ID] ,Year))
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		=' The values selected in year field are' &chr(13)&
Concat(DISTINCT Year,CHR(10),-Aggr(NODISTINCT SUM(Sales),Year))
or
=' The values selected in year field are' &chr(13)&
Concat(DISTINCT Year ,chr(13),-Aggr(NoDistinct Sum(Sales),[Product ID] ,Year))
 
					
				
		
Thanks manish,
Can you throw some light on whats happening with that "NoDistinct" in the Aggr
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 
					
				
		
Thanks for the links
