Search results

  1. S

    Duplicate Row to be deleted on the basis of a single field

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

    Sequence missing to be tracked

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

    Unique records required

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

    Help needed on Dlookup

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

    How can i export data in Xlsx format

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

    To know basics of access

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

    Introducing to myself

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