Copy a date from one column to another with a macro

[Saxie1]

I am working with an Access97 database that I did not write, but need to edit large amounts of data in. The two columns of interest are adjacent to each other. The first column contains a valid date but the second does not.

Column 1 Column 2
6/16/2003 12:16:12 AM 12:00:00 AM
6/15/2003 10:44:06 PM 12:00:00 AM

I want to create a macro that will copy the data from Column 1 into Column 2 and add 2 minutes to it for each record.

Here is a portion of what I have tried so far:
runcommand - copy
sendkeys - {TAB}
runcommand - paste

The copy command works (I can manually press {^V} and the data pastes), but the paste command doesn't do anything. I have tried to use the sendkeys {^V} command but I get the infamous "Need to Load" sendkeys error.

Any suggestions??

 

[DrSimon]

Why use a macro to do this? It's much easier to do as an update query. Use the Dateadd function with "n" as the interval, 2 as the number and [Column 1] as the date
Simon Rouse

 

[Saxie1]

Simon you are an AWESOME individual!! I tend to do things the hard way, so this was a big change of pace for me.

Thank you for the help!!!

 

[DrSimon]

It often takes a lot of experience to do things simply. We forget that there are times when pen and paper is the best solution to a problem!
Simon Rouse