Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    Unanswered: Clearing cells within a table

    Hey group,
    I've tried to look this up in past entries and I did not come across this, so if it's been talked about before, I apologize.
    I have a table that contains data for names, areas, and tests. I would like to be able to periodically clear the data in the test columns (there are several columns too), but leave the data for names and areas. That way we start out with blanks instead of carrying over data. Is there some visual basic code to accomplish this? Thank you for any help.


  2. #2
    Join Date
    Sep 2003
    UPDATE SomeTable SET TestColumn="", ... ,TestColumnXXX='' WHERE ( ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Sep 2004
    Charlotte, NC
    Not knowing if the Test Scores are letter grades or numeric grades, I would suggest a query based on the following SQL:

    UPDATE TestScores SET Test1 = Null, Test2 = Null, Test3 = Null;

    This is based upon a Table called 'TestScores' with fields of Name, Area, Test1, Test2, and Test3. Modify it for your own table structure.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts