Anybody know MS Access?

Discussion in 'Bulletin Board ARCHIVE' started by E.I. Addio, Sep 21, 2005.

  1. E.I. Addio

    E.I. Addio Well-Known Member

    Joined:
    Jul 17, 2005
    Messages:
    6,207
    Likes Received:
    113
    Trophy Points:
    63
    Location:
    Oakwell, where else
    Home Page:
    Style:
    Barnsley (full width)
    #1 E.I. Addio, Sep 21, 2005
    I want to automatically set a value in a field based on the result entered in another.
    In Excel it would look like =if(A1="TRUE",1,0)

    Is this possible in Access?
     
  2. Redstar

    Redstar Well-Known Member

    Joined:
    Jul 18, 2005
    Messages:
    26,953
    Likes Received:
    2,050
    Trophy Points:
    113
    Location:
    Fidel's Bedside
    Style:
    Barnsley (full width)
    #2 Redstar, Sep 21, 2005
    I believe it is possible. Can't really remember how to do it. There are some great Excel/Access forums out there. Try Mr.Excel.com, they have an Access Forum
     
(You must log in or sign up to post here.)

Share This Page