Copy and Paste Dates in a Query

P

Philip

This is something probably dead simple, but here we go.

Im trying to copy and paste a date from one table into another (long story)
rather than retyping all the dates in again. I created a query with the two
tables and the two date fields. Ran the query and tried to copy one date
from one field and paste it into the corresponding empty date field.

All i get is "the value you entered isnt appropriate..."

Ive got over four hundred to move over so why cant i copy and paste 'on mass'

Answers on a postcard....
 
O

Ofer

Can you please post the SQL you have tried?

When you tried to update a date, did you put the date in #?
#1/1/2005#
 
S

Steve Schapel

Philip,

It sounds like you would be better to consider an Update Query or an
Append Query. Copy/Paste is not a great approach in a database.
 
Top