Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    225

    Unanswered: Replace Values In a Table using Macro/query

    I have a table that stores some figures (the table is created each time using a maketable query)

    One of the fields stores "Target Times"

    some of the targets are less than 5 mins and some are over 5 mins,

    For each record that is under 5 mins i need to update it with a "5"

    Example:

    Code 1 - Target = 20 mins (no change required)
    Code 2 - Target = 3 mins (I need the 3 replaced to a 5)

    Please help

    Andy

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    UPDATE WhatEverTable SET WhatEverColumn=5 WHERE (WhatEverColumn<5);

    Next question ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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