Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005

    multiple iif statement NEED HELP PLZ

    I hope I can explain this correctly:

    I have a report that I want to have a field come up with a caclulation depending on 2 criteria.

    The first thing I want it to check for is the field called lastname. this report usually produces 4-8 names upon date selection. I have 2 employees that get paid differently then the other guys. Their calculations will be lower then the other guys.

    FIRST --> I need the field in the report to first check the lastname field for these 2 different employees (We will say emp 1 and emp 2). The other employees (We will say emp 3) will have [text44]*0.0815. The 2 different employees will have [text44]*0.0765,

    Doesnt sound hard except that the report also needs to determine in the same field, if [monthly bonus] field is >0 for emp 1 and 2. If the [monthly bonus] field is >0 then the following equation occurs: iif([monthly bonus]=0,([text44]-[travel exp])*0.0765,([text44]-[monthly travel])*0.0765)

    I am having a tremendous trouble on trying to use multiple iif statements so the field can make the right calculations.


    Scott Munkirs

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    That's really the wrong approach.

    Create a separate table with employee, rate, expenses etc. and then incorporate that table in your query.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Syntax Error In Insert Into Statement
    By frankvfox in forum Queries
    Replies: 1
    Last Post: 09-09-2008, 12:35 PM
  2. Replies: 0
    Last Post: 05-17-2008, 01:18 AM
  3. IF Statement with Minutes
    By sal_gxer in forum Queries
    Replies: 0
    Last Post: 02-12-2007, 08:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums