Results 1 to 4 of 4
  1. #1
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    528

    Total account query

    Hello guys
    I've calculated my job query total student grades and then shows me the stairs rate, which works just fine.
    But I want an additional field a(Expr2) as in the picture. The thus: -
    If the rate is less than 50 shows me zero.
    Any help ... Thanks in advance


    Click image for larger version. 

Name:	1.JPG 
Views:	9 
Size:	23.6 KB 
ID:	22092Click image for larger version. 

Name:	2.JPG 
Views:	9 
Size:	27.2 KB 
ID:	22093

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 64bit Access 2013
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,538
    In the new field: Expr2=IIF([Rate]<50,0,Int([Rate])

  3. #3
    JamesDeckert is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jul 2015
    Location
    Salina, KS
    Posts
    262
    expr2:iif([Total score]/4<50,0,[Total score]/4)

  4. #4
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    528
    Thank you very much, my friend JamesDeckert

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

Similar Threads

  1. Crosstab query of monthly account totals
    By chasew in forum Queries
    Replies: 2
    Last Post: 08-11-2015, 11:12 PM
  2. Replies: 5
    Last Post: 09-17-2014, 07:28 PM
  3. Replies: 17
    Last Post: 11-06-2013, 05:38 PM
  4. Overdue Account Query- Access 2010
    By lfarring in forum Queries
    Replies: 3
    Last Post: 06-04-2013, 03:31 PM
  5. Getting one account from 15,000
    By citygov in forum Programming
    Replies: 4
    Last Post: 10-21-2011, 02:27 PM

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