6 Comments

1. rizalmovic says:

   July 27, 2011 at 9:30 am

   Thank you for this helpful article..

   Reply to this comment
2. Jeffrey Cox says:

   December 1, 2010 at 1:07 pm

   Derek –

   Thanks for this article. I needed a way to create a duplicate set of records in a table for one of the records management systems we sell and support. In the past, I’d query out the data, then massage it into an INSERT query, run it, then have to go do the same thing again. Now, taking your code and adding some criteria, all I have to do is change an ID (like your WHERE statement) and, waa-laa, I’m done! Much appreciated!

   – Jeffrey

   Reply to this comment
   • Derek Dieter says:

     December 1, 2010 at 9:15 pm

     Cool, glad it helped!

     Reply to this comment
3. Dennis says:

   August 29, 2010 at 8:39 am

   Oh, forgot to say, I’m using Access 2007.

   Reply to this comment
4. Dennis says:

   August 29, 2010 at 8:37 am

   I’m kind of a newbee at this. I have a table that I enter a techs start time and end time on a service call. I figured out how to use a query and “DataDiff” to calculate the amount of time the tech spent on the job. Now I need that calculated result inserted into the Service Call form after the Start Time and End Time entries.

   It should be simple but I can’t seem to get it to work.

   Thanks

   Reply to this comment
   • Derek Dieter says:

     August 30, 2010 at 9:24 pm

     Ok, let’s see. So you need the DateDiff result to be inserted into the same row. First you would add the column to the table.

     ALTER TABLE ServiceCalls ADD CallTimeMins int

     UPDATE ServiceCalls
     SET CallTimeMins = DATEDIFF(minute,StartTime, EndTime)

     This will update the table one time. Use caution however because it will update every row in the entire table.

     Does that help?

     Reply to this comment