Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2016
    Posts
    8

    Unanswered: Exclude names from query

    Hello,

    I am trying to exclude the association fee for board members in a query. The association fee is a calculated field which multiples a 10% fee of the payment. (0.1 *NZ([Payment])

    I used the Not "Name(board member)" under the criteria box but when i run the query the fee for the member is still there.

    How do you make sure the fee is set to 0 when a name is mentioned?
    Click image for larger version. 

Name:	Capture3.JPG 
Views:	2 
Size:	79.5 KB 
ID:	16980
    Result:
    Still shows the fee.
    Click image for larger version. 

Name:	Capture4.JPG 
Views:	3 
Size:	33.2 KB 
ID:	16981

    Thank you!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    How do you know if someone is or isnt a board member?
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2016
    Posts
    8

    members

    I have the list of board members saved from the employees table.

    Would a IIF function work on excluding the name from the association fee?

    AssociationFee: 0.1*Nz([MPayment]) «Expr» IIf(Name of board member=Name of board member, 0,)

    How would you set the expression of the members name?

    «Expr» IIf(«expression», «truepart», «falsepart»)

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    So if you have the list saved from the employees table where is it stored?
    Normally id expect a column in a suitable table that identifies this piece of data. That could be a boolean (yes/no) called say isBoardMember.
    It could be a column called membertype that is a fk to say a memberstypes table.

    From your questiobs so far in my books you need you study up on db design
    That means understanding normalisation, relational theory
    Get to grips with JOINS
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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