Results 1 to 2 of 2

Thread: if or case in query....

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Mar 2005
    Posts
    2,586

    if or case in query....

    Code:
    
    
    Round((([CONF]+[R1]*0.75+[R2]*0.5+[R3]*0.25)/[OB]*10),2)

    NOTE:
    i use Access database
    Last edited by luca90; Mar 31st, 2017 at 06:13 AM.

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,344

    Re: if or case in query....

    Perhaps try providing a FULL and CLEAR explanation of the problem. We're not mind readers.

Posting Permissions

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



Click Here to Expand Forum to Full Width