Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Unanswered: IF-THEN expressions in Access

    All,

    I am an advanced Excel user who is trying to shift some of my databases to Access. I routinely use the tools in Excel to manipulate data and return certain results. For example:

    If the sum of two cells (fields) is = or > 12, I need to have another column show 200.

    I am used to using multiple IF statements in Excel to serve this purpose, but was wondering how I could make this happen in Access.

    Any info would be greatly appreciated.

    Thanks.

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Lightbulb Context?

    On a form, report, query?
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Jan 2004
    Posts
    3

    Re: Context?

    Originally posted by garethdart
    On a form, report, query?
    Generally in a query, to return those values that I could have in Excel, and eventually to use in a report or form.

  4. #4
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Lightbulb query

    Quick query examples:
    Attached Thumbnails Attached Thumbnails query.gif  
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  5. #5
    Join Date
    Jan 2004
    Posts
    3

    Thank you

    Thanks for the help. . . That's just what I was looking for.

Posting Permissions

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