Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    13

    Unanswered: Validation query help

    Hello everyone,

    I am very new to MS access, and basically any other database application. I don’t know if I am using the proper term, validation, but here is what I want to do…

    I need a query function that will look at my data (just one ‘field’ of numbers) and have it automatically assign it a certain number. For example, if there was a number ( 1 ) in my data, I would like the function to give it a ( 99 ) in a new field2., if there was a number ( 2 ) in my data, I would like the function to give it a ( 88 ) also in my new field2. And so on

    My data has only a few different values in it so the function isn’t going to be super long. I do need all my new assigned numbers in the same field thou when the query creates it. If you need to know anything else please let me know.

    thanks in advance,

    John

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    You just need a simple update query
    Can field2 be mathematically calculated from field1, or do you just have
    a list of predetermined values?
    Is this just a one time update, or will it be done routinely?

    If it were just a one time update, and a small number of values,
    I'd just do it like this:

    Code:
    UPDATE YOURTABLE
    SET FIELD2=99
    WHERE FIELD1=1
    I'd just run this query several times, changing the values each time.
    Inspiration Through Fermentation

  3. #3
    Join Date
    Nov 2006
    Posts
    13
    EDIT : I got it to work!!

    Thank you RNG for the help!
    Last edited by smokinflapjack; 01-15-07 at 16:53.

Posting Permissions

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