>In a report I'm working on, I need to calculate a summary of the average days to close. Some detail lines have a Zero AVGDAYS, and I don't want those included in my overall average... How to do this?
>
>Grace and peace,
>John
SELECT * from YourTable
WHERE avgdays > 0
INTO CURSOR allavgdays
And then run the report off of that.
HTH,
George
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe