Click here to Skip to main content
15,895,084 members

Comments by katumbamartin (Top 4 by date)

katumbamartin 17-Aug-16 10:16am View    
Hi David,
Thanks for the answer.
I would like to make my question more clear.

Actually, i have only one Table; that is Table1. Table2 Should be coming from an sql select statement which am looking for now.

When you look at the columns for development, there only two records under development, so what i need is to have a query which can pull up all records in Crops Columns, so that i can get rid of empty rows cells appearing above 'Mangoes'. My desired outcome should be as in Table2
katumbamartin 19-Jul-11 10:43am View    
I want the system to take only the smallest eight values. if in that case the 8th and 9th entry are equal, it should be taking one

Like in my example, those are the smallest eight entries i have
katumbamartin 18-Jul-11 5:51am View    
Hi digimanus, the answer should be 23 in that case
katumbamartin 17-Sep-10 8:20am View    
Reason for my vote of 5
Automatic vote of 5 for accepting answer.