Search results

Hi, I need help in finding the First to fourth highest numbers in four columns. For Example: Student Name Subject1 Subject2 Subject3 Subject4 Max 60 40 50 10 I need help in query to find the first, second, third and fourth highest marks in...

Hi Team, I have attached the excel document which needs to do it in the access. In the excel Col A, B, C are the raw data values, the highlighted in the yellow color (Col E and G ) should be the output. In the col E and G i have applied some formulas in the excel which really works out. I...

Hi Team, I 'm downloading the excel data from the site and connecting it to access. In excel the particular column (Time Taken) is in the format of "00:12:26". After connecting it to access and appending it to the table, the format changed to "12:12:26", the first two digits changed to "12"...

Hi Team, I'm working on the special project in my office. In that i'm fetching the data from the excel sheet-Field Name "Location" The catch is Location has the format example: SSSIndiaXXXXX and SSSPhilipinesXXXX. I need to separate the SSSIndia and SSSPhilipines in the field. Like that new...

Hi , I'm using Access 2010. It seems like IIF and Switch accepts only 13 to 15 conditions, above 15 both IIF and switch are not working. Its showing an error message as "Too complex". I have 362 conditions to complete. Is there any other function can support more than 300. Please Help...