Welcome to SPN

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

Sign Up Now!

Delete Contents of a Field

Discussion in 'Information Technology' started by Kevin, Jul 28, 2006.

  1. Kevin

    Kevin
    Expand Collapse
    Guest

    Hello,

    I have a table with over 1000 records. Every three months we have to clear
    the contents of a date field. Is there an easy way to clear that field
    without having to go into each record and delete the contents?

    Thank you.
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Use an Update query to set the date to null.

    1. Create a query that uses this table.

    2. Change it to an Update query (Update on Query menu.)
    Access adds an Update row to the grid.

    3. Drag the date field into the Query grid.

    4. In the Update row under this field, enter:
    Null

    5. Run the query.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Kevin" <Kevin@discussions.microsoft.com> wrote in message
    news:52BA103A-FA35-4070-8D8A-A16E687588F7@microsoft.com...
    > Hello,
    >
    > I have a table with over 1000 records. Every three months we have to
    > clear
    > the contents of a date field. Is there an easy way to clear that field
    > without having to go into each record and delete the contents?
    >
    > Thank you.
     
  4. Kevin

    Kevin
    Expand Collapse
    Guest

    THanks a lot!

    "Allen Browne" wrote:

    > Use an Update query to set the date to null.
    >
    > 1. Create a query that uses this table.
    >
    > 2. Change it to an Update query (Update on Query menu.)
    > Access adds an Update row to the grid.
    >
    > 3. Drag the date field into the Query grid.
    >
    > 4. In the Update row under this field, enter:
    > Null
    >
    > 5. Run the query.
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Kevin" <Kevin@discussions.microsoft.com> wrote in message
    > news:52BA103A-FA35-4070-8D8A-A16E687588F7@microsoft.com...
    > > Hello,
    > >
    > > I have a table with over 1000 records. Every three months we have to
    > > clear
    > > the contents of a date field. Is there an easy way to clear that field
    > > without having to go into each record and delete the contents?
    > >
    > > Thank you.

    >
    >
    >
     
  5. Marcin

    Marcin
    Expand Collapse
    Guest

    U¿ytkownik "Kevin" <Kevin@discussions.microsoft.com> napisa³ w wiadomo¶ci
    news:8F49D09F-E90F-4E35-B7B1-80478174A24D@microsoft.com...
    > THanks a lot!
    >
    > "Allen Browne" wrote:
    >
    > > Use an Update query to set the date to null.
    > >
    > > 1. Create a query that uses this table.
    > >
    > > 2. Change it to an Update query (Update on Query menu.)
    > > Access adds an Update row to the grid.
    > >
    > > 3. Drag the date field into the Query grid.
    > >
    > > 4. In the Update row under this field, enter:
    > > Null
    > >
    > > 5. Run the query.
    > >
    > > --
    > > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > > Tips for Access users - http://allenbrowne.com/tips.html
    > > Reply to group, rather than allenbrowne at mvps dot org.
    > >
    > > "Kevin" <Kevin@discussions.microsoft.com> wrote in message
    > > news:52BA103A-FA35-4070-8D8A-A16E687588F7@microsoft.com...
    > > > Hello,
    > > >
    > > > I have a table with over 1000 records. Every three months we have to
    > > > clear
    > > > the contents of a date field. Is there an easy way to clear that

    field
    > > > without having to go into each record and delete the contents?
    > > >
    > > > Thank you.

    > >
    > >
    > >

    ===========================================================================
    FULL LEGAL SOFTWARE !!!
    Games, video, program, image, chat, questbook, catalog site, arts, news,
    and...
    This site it is full register and legal software !!!
    Please download and you must register software !!!

    PLEASE REGISTER SOFTWARE:
    http://www.webteam.gsi.pl/rejestracja.htm
    DOWNLOAD LEGAL SOFTWARE:
    http://www.webteam.gsi.pl

    Full question and post: http://www.webteam.gsi.pl

    Contact and service and advanced technology:
    http://www.webteam.gsi.pl/kontakt.htm
    FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

    Please add me URL for you all site and search engines and best friends !!!

    Me site:
    SERWIS WEBNETI: http://www.webneti.gsi.pl
    PORTAL WEBTEAM:http://www.webteam.gsi.pl
    LANGUAGE: http://www.webneti.cjb.net

    ==========================================================================
     

Share This Page