Copy and Paste Dates in a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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....
 
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#
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format question 3
Copy/Paste 2009 dates into Tbale and they Show as 2008 Dates 1
copying & pasting forms 2
Using DateAdd and IIF conditions in a Query 2
Append query to Paste Errors table ? 2
Date format in Query 1
Truncate date 5
query for date 3

Back
Top