Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Copy and Paste Dates in a Query

Discussion in 'Information Technology' started by Philip, Oct 28, 2005.

  1. Philip

    Philip
    Expand Collapse
    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....
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Akal Takht concerned on drug addiction, copying during exams Breaking News Nov 5, 2013
    SciTech New Quantum Dot Technique Combines Best of Optical and Electron Microscopy Breaking News Jun 17, 2013
    India Copy of 48th Rreport of 'LOKPAL BILL 2011' Presented in Parliament Breaking News Dec 10, 2011
    Bhagats Sheikh Farid Copyright? History of Sikhism Nov 14, 2011
    Christianity Public library find is only surviving copy of rebel hymn book Interfaith Dialogues Jan 8, 2011

  3. Ofer

    Ofer
    Expand Collapse
    Guest

    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#
    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benifit from it.

    Good luck



    "Philip" wrote:

    > 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....
     
  4. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    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.

    --
    Steve Schapel, Microsoft Access MVP


    Philip wrote:
    > 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....
     

Share This Page