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 biv343 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
  • 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

    iff 102 then change it to 0102

    This might work: IIf(Val([Org_Code])>0,'0' & [Org_Code],[Org_Code])
  4. 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