Hi Michelle,

No there isn't.

IIF(netwgt=0,000.00,ROUND(MTON(amount)/netwgt,2)) AS priceper

Reads as:

IF netwgt = 0
   ROUND(MTON(amount)/netwgt,2))
ELSE
   ???
ENDIF

>Sure there is.
>
>IF netwgt = 0
> priceper = 000.00
>ELSE
> priceper = ROUND(MTON(amount)/netwgt,2)
>ENDIF
>
>
>I'm not sure what you're seeing that I don't. It looks fine to me... And runs just fine the first time.
>
>Thanks,
>
>Michelle
>
>
>
>
>>Michelle,
>>
>>But it's unbalanced... There is no "what to do if False" side of the equation.
>>
>>>>
>>>>I don't know if it's "the" problem, but your priceper logic is flawed. It states:
>>>>
>>>>IIF(netwgt=0,000.00,ROUND(MTON(amount)/netwgt,2)) AS priceper
>>>>
>>>>So, if netwgt is not 0 (and what the heck is that comma doing there?) then what is priceper?
>>>>
>>>
>>>priceper is ROUND(MTON(amount)/netwgt,2). The amount divided by the new weight rounded to 2 decimals.
>>>
>>>Which comma are you talking about? The first two are part of the IIF and the last one is for the ROUND.
>>>
>>>The IIF is just to prevent a divide by 0 error. I have this same code on a different SQL and it works fine without crashing. In fact, the whole SQL is the same except it uses totamt instead of lnAmount.
>>>
>>>Thanks,
>>>
>>>Michelle
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>>>I have this code:
>>>>>
>>>>>

>>>>>SELECT Argltr
>>>>>SUM amount TO lnAmount FOR (LEFT(glcode,1) $ "DGN") AND (BETWEEN(invdate,pdBegin,pdEnd))
>>>>>
>>>>>SELECT "X" AS metal, company, amount, netwgt, IIF(netwgt=0,000.00,ROUND(MTON(amount)/netwgt,2)) AS priceper, ;
>>>>>       IIF(lnAmount=0,000.00,ROUND((MTON(amount)/lnAmount)*100,2)) AS percsale ;
>>>>>FROM argltr  ;
>>>>>INTO CURSOR ccstc ;
>>>>>WHERE (LEFT(glcode,1) $ "DGN") AND (BETWEEN(invdate,pdBegin,pdEnd)) ;
>>>>>ORDER BY amount DESC
>>>>>
>>>>>pcTitle = "TORRANCE CASTING INC."+CHR(10)+ ;
>>>>>          "CORP. SALES TO CUSTOMER"+CHR(10)+ ;
>>>>>          "BY SALES $$"+CHR(10)+ ;
>>>>>          "FOR "+DTOC(pdBegin)+" THRU "+DTOC(pdEnd)
>>>>>
>>>>>REPORT FORM (gc_adrvprg+"ccstc") TO PRINTER PREVIEW
>>>>>

>>>>>
>>>>>When I run it the first time, it runs fine. But if I run it again, it crashes on the SQL SELECT. If I comment out the report call, I can run it over and over with no problems. But as soon as that report runs, the next time it hits the SQL, it crashes. By crashes, I mean crashes VFP.
>>>>>
>>>>>I don't have a clue what could be wrong. Any ideas?
>>>>>
>>>>>Thanks,
>>>>>
>>>>>Michelle