Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GunVi
  • Content: Threads
  • Order by date
  1. GunVi

    Sorting data in Excel from Access

    Hi, I am exporting data (5 queries) from Access into an existing Excel spreadsheet (5 worksheets) using CopyFromRecordset. This, however, does not preserve the sorting order of the data. Thus, I have to sort the data in the spreadsheet using code. This code works fine for the first worksheet...
  2. GunVi

    Using value in previous and next records to get admit & discharge date

    Hi, I have a patient location table with patient ID, location, start date, end date and service. This data is generated by the admission and discharge system. I have two issues that need to be solved. They are: 1) Make sure that the data is cleaned and the correct records are considered for...
  3. GunVi

    Using values of previous records to calculate dates

    Hi, I have a patient location table with patient ID, location, start date, end date and service. This data is generated by the admission and discharge system. I have two issues that need to be solved. They are: 1) Make sure that the data is cleaned and the correct records are considered for...

Part and Inventory Search

Back
Top