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...

Any body can help me for my post

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 thanks team. I got it

I got another question. In the excel I have chat field. The time format for few cells comes with date. The Excel raw data what i'm using for my project it will be read only, so i'm not able to make any changes. I'm will upload the data to MS access 2010. In MS Access i tried many times to...

There is no AM in the excel. I cant do anything in excel, its readonly . And day on day new data gets added .i want make changes in the access itself. How to do that. Please help.

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, Thank You So much. Its working fine. Thanks, Kishore

Hi team, I tried in access 2010. Its not coming correctly. Can any one help on this. Ex: sss - countryname- personname I need to separate sss , countryname, personname and put it in each field. Please help. I want use this access 2010

Hi Alex, It's separating the Countryname and Personsname. And one more question I'm using Access 2007 and Access 2010. Is it possible to separate. Thanks, Kishore Kumar.R

Hi Alex XXX is the persons name, the length will change. Below is the format SSSCountryname-Personsname SSSIndia-Kishore SSSPhilipines-Rkishorekumar I will be doing reports for different locations. So the country name gets changed. I need to separate SSSConuntryname and Personsname...

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 Thank You So much, I try this out and let you know. Thanks KK

Hi, Here is the situation Days Tenurity 7 Week 1 8 Week 1 15 Week 2 22 Week 3 29 Week 4 36 Week 5 43 Week 6 50 Week 7 57 Week 8 64 Week 9 71 Week 10 78 Week 11 85 Week 12 92 Week 13 99 Week 14 106 Week 15 113 Week 16 120 Week 17 127 Week 18 134 Week 19 141 Week 20 148 Week 21 155 Week 22 For...

Thank You for your response. How to use select case or Dlookup in Build query section. Is there any example you can provide? Thanks, KK

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...