Thanks Stephen for your close evaluation of my syntax! I didn't know about the IYR4 command - that will come in real handy as I kinda get lost with all those parens! As far as the 3rd statement goes, I actually do want to use the IAmt, because that invoice has been canceled, the PAmt would be zero and I'm looking for lost revenues!! Maybe if I don't use the (sum(iamt)) and simply use the amount then I wouldn't need the group by - will have to play with this and see. I do agree that I can do the sums on a break footer - don't know if there will be any speed difference. Thanks again for your help - I sure do appreciate it!!

Jan Barley

Reply via email to