Re: "OR" IN QUERY

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Graeme Richardson (graeme_at_wave_nospam.co.nz)
Date: 05/10/04 

Date: Tue, 11 May 2004 07:52:21 +1200

Hi Bill, the OR(Expr1, Expr2, ...) syntax is for Excel. It won't work in MS
Access
MS Access requires Expr1 OR Expr2 OR ...

Hence your statement becomes:

PRICE: IIf(([INVOICE DETAIL]![ITEM TYPE]="MATERIALS" OR
[INVOICE DETAIL]![ITEM TYPE]="SUBCONTRACT"),ROUND
([QUANTITY]*[RATE]*1.265,2),ROUND([QUANTITY]*[RATE],2))

Hope this helps, Graeme.

Relevant Pages

  • Re: The LOOP macro (was Re: Be afraid of XML)
    ... > The thing that has always bugged me about C's for loop is that the ... Bad things about that diagram: ... expr2 is evaluated, when in fact expr2 is the value tested zero/nonzero ... horizontally as is usual in the syntax; ...
    (comp.lang.lisp)
  • Re: Natural size: int
    ... expr2) is a signed integer type that can hold values ... the syntax for suffixed literals is becoming unwieldy ... that 456P32U specifies an unsigned 32-bit constant with the value 456. ... literal is the immediate operand of a cast to a numeric type, ...
    (comp.lang.c)
  • Changing a SQL Instuction
    ... I'm trying to do a consult in access from excel, ... Expr1). ... RATEIO' AS Expr2, ...
    (microsoft.public.excel)
  • Re: find and NFS mounts
    ... This is taken from the findmanpage on a Slackware 11.0 system. ... the directory tree rooted at each given file name by evaluating the ... Same as expr1 expr2. ...
    (comp.os.linux.misc)
  • Re: proper syntax for checking values of multiple variables
    ... On the line above where I have 'ERROR IS HERE' my xterm is complaining about: ... True if both expr1 and expr2 are true. ... supported by your shell, and instead of testing for a negative "NOT " it's clearer to test for a positive "empty", and if you just want to test for all of them being empty, you don't need to test them all individually so all things considered I'd go with just: ...
    (comp.unix.shell)