acccess 2007

Discussion in 'Computers' started by ShiftZZ, Feb 23, 2010.

  1. ShiftZZ

    ShiftZZ Funster Life Member

    Joined:
    Feb 19, 2008
    Messages:
    19,821
    Likes Received:
    35,877
    Location:
    Leicestershire
    I haave a large database and I have imported a large number of records, the only this was I forget to add a date, so all the data records are blank.

    Is there a way of changing a blank field into to days date?



    Ta

    ShiftZZ
     
  2. 656

    656 Read Only Funster

    Joined:
    Jul 30, 2007
    Messages:
    1,150
    Likes Received:
    291
    Location:
    The universe
  3. johngee

    johngee Read Only Funster

    Joined:
    Aug 19, 2009
    Messages:
    59
    Likes Received:
    0
    Location:
    Hampshire, UK
    Create an update query. Type 'create an update query' in Help if you need to. You can update the field you specify from blank/null to whatever. You may need to look at the design of your table to ensure that the blank field is in a date format. If not, change it.
     

Share This Page