Search results

Thanks sir for this favour. How can we get the same result when count FIeld is not available in the table

Greetings to everyone ! I want to delete the Duplicate rows on the basis of a field named as Finalname. i want to do it through SQL query therefore pls favor .

Dear Friend, As suggested, i had tried post no 3 but i am not understanding how it is to be executing therefore i need your favour once again. Query to be designed on the DB which is posted by me in post #8. Thanks in advance for the nice support.

Dear Friend missing no to be tracked in the attached database therefore please your support is needed on the same.

I hereby attaching the data to get the missing numbers . i have deleted the '1492337' of lane 3 from the dB so it shall be missing no sure .

Greetings to everyone ! Column A containing "sequence no" and column B containing User detail so i would like to know that which are the nos are missing of each user. Required result is provided in the column C of attached table. Thanks in advance for the cooperation received.

Higher value required for each name Name trips class Result a 4 1st 1 a 4 2nd 2 a 4 3rd 3 b 4 4th 5 From the above data,i want to fetch the complete records for each name where he has achieved highest in...

thanks a lot for replying. actually it is not working and giving all the four enteries. 2. i want to make the query through SQL view.

Name trips class a 4 1st a 4 2nd a 4 3rd b 4 4th From the above data,i want to see only those records which are unique in Name "field" . Result for the above data is :- Name Trips Class b 4 4th Name "A" is more than 1 times in the data so...

i am trying to fetch the result in query 1 through joining but it is not being done therefore i want to get the result in query 1 which i have shown in column 3 and 4 of Table 1. Please provide the solution and i shall be highly thankful to you for this favour.

In my attached DB, i have made a query in which i am trying to fetch 'AVC Class Code' from 'Fare Table' through D LookUP but it is not working therefore please help me on the same.

i have 300000 rows in access query and when i am exporting this Database then access is exporting only 65000 row. i want to export the Database in Xlsx format so that all 300000 row could be export in a single excel workbook thanks in advance for nice support.

1.Is access compatible to work on more than 1 crore rows if size is between 10 to 15 GB. 2. Please suggest how to use D lookup for complete field in a query

Good evening ! Myself Ram Mher and resident of India . I want to learn the basics of access so request you all for favouring me.