UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Query To Group And Concatenate Fields, Access 2013    
 
   
ADezii
post Jun 17 2019, 02:04 PM
Post#21



Posts: 2,461
Joined: 4-February 07
From: USA, Florida, Delray Beach


  1. I downloaded your Spreadsheet, Imported it into my Demo Database, and appended the Data into an empty tblData.
  2. The Record Count was 35,080 Records.
  3. I ran a series of six Trials and computed the Average Processing Time to be 41.43 secs.
  4. The PC where the Code was executed was an older Pentium 1.6GHz with 512MB of RAM. This was the only PC I could find in work with Access installed.
  5. The Operating System was Windows XP (wow, that's old).
  6. Access Version was 2007.
  7. Your Average Processing Time should be much faster with a higher end PC.
  8. Download the Attachment which contains your Data in tblData. The Code will be executed, and the results will be displayed along with the Processing Time.

Attached File(s)
Attached File  PseudoDB_Revised_2.zip ( 833.17K )Number of downloads: 3
 
Go to the top of the page
 
2 Pages V < 1 2


Custom Search


RSSSearch   Top   Lo-Fi    20th July 2019 - 06:36 AM