>After posting I thought about and did what Al suggested. I hate report variables. I have 4 summary bands and 4 columns i have to do this to.
>
>Thanks for help Al and Naomi
You're welcome. Did you go with pre-computed columns in a cursor, or with report variables? I always use a cursor, the logic's all in one place and I find it easier to debug if something's wrong with my logic.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up