Copy data from one field to another in same table

[maacky99]

I have a field called Shipdate. I have created a new field that is called invoicedate. What I want to do is copy all of the shipdates and paste them in the invoicedate field for my old records. From here on out they would be distinct fields but for old records and reporting purposes I need those dates.

Can I do that in a query, do I need a module???

It's probably easier than I think it is.

Thanks.

 

[pbaldy]

A query will do it:

UPDATE TableName SET invoicedate = Shipdate

You may want to add a WHERE clause so that only the appropriate records get updated.

 

[maacky99]

Thanks pbaldy - that worked like a charm