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
Results 1 to 2 of 2
-
3 Star Lounger
- Join Date
- Jan 2001
- Location
- Baltimore, MD, Maryland, USA
- Posts
- 254
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2001-09-08 03:36Sorting Times Using VBA or SQL (OFFICE 97 SR2)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Uranium Lounger
- Join Date
- Jan 2001
- Location
- South Carolina, USA
- Posts
- 7,295
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2001-09-08 17:29Re: 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
