Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting Times Using VBA or SQL (OFFICE 97 SR2)

    Hi:
    I have production start and stop times in a database for items that we produce. I need to write a query that reviews two-year
    Attached Files Attached Files

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting Times Using VBA or SQL (OFFICE 97 SR2)

    Doing this in Excel is going to be a bit difficult if you have 300,000 records. The max number of rows in a worksheet is 65,536. I have run ACCESS querries that sorted that many records, and it didn't take forever. I would suggest doing it in ACCESS.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •