acccess 2007

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

  1. ShiftZZ

    ShiftZZ Funster Life Member

    Joined:
    Feb 19, 2008
    Messages:
    20,059
    Location:
    Leicestershire
    Ratings:
    +42,815
    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

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

    johngee

    Joined:
    Aug 19, 2009
    Messages:
    59
    Location:
    Hampshire, UK
    Ratings:
    +0
    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