>I was trying to get SET CENTURY OFF/ON to run in the band entry/exit but it wouldn't, so I created proc call and that seems to work OK.
>
>Thanks.
>Luke
Why?
It doesn't seems right to me. If CENTURY is OFF it must be OFF for the whole report, not only for some band(s). But this is your report of course :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.