Re: IIF Syntax
- From: "Jeff Boyce" <nonsense@xxxxxxxxxxxx>
- Date: Thu, 5 Oct 2006 08:56:56 -0700
Paul
Perhaps it is insufficient caffeine this morning, but I don't understand
what problem you are having.
(if you wish to exclude "nulls", use a WHERE clause to do that)
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Paul LeBlanc" <PaulLeBlanc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4DC588BB-0723-4A4A-B151-7178FBD230E5@xxxxxxxxxxxxxxxx
I'm having a problem with the following statement
SOURCE:
IIf(Mid$([TblProp]![SOURCE],1,2)=[TblSTAGE]![STAGE],[TblSTAGE]![STAGENAME])
When I added it to the SQL statement
SELECT TblPROP.CODE, VARIETY.NAME, TblPROP.PLOT, TblPROP.DATEIN,
TblPROP.DATEOUT, TblPROP.QTY, TblPROP.LOC, TblPROP.SEQ,
IIf([Qty]<315,1,Int([QTY]/315)) AS [ROWS],
IIf(Mid$([TblProp]![SOURCE],1,2)=[TblSTAGE]![STAGE],[TblSTAGE]![STAGENAME])
AS SOURCE, "*" & [CODE] & [PLOT] & [LOC] & [SEQ] & "*" AS BC
FROM TblSTAGE, TblPROP INNER JOIN VARIETY ON TblPROP.CODE =
VARIETY.ItemCode
WHERE (((TblPROP.DATEIN)=[STICK WEEK ?]))
ORDER BY TblPROP.LOC, TblPROP.SEQ;
I get thousands of results, most with the source field null but always
with
one that is right
.
- Prev by Date: Re: need to extract specific characters from field
- Next by Date: Re: How to calculate time using this function
- Previous by thread: Re: How to calculate time using this function
- Next by thread: Re: Find uppercase letter in a string
- Index(es):
Relevant Pages
|
