Hi,

Not sure what a MS Access "transform" is but have you looked at using
a decode statement within Oracle. In effect you can use this as an IF
than Else statement even on dates and numbers. So you should be able
to produce for example reports showing Year todate Revenue in a colum
next to MOnthly revenue..

Hope this helps

Andy
Koios Associates
www.koios-associates.com

"António Matos Rodrigues \(casa\)" <matos.rodrigues (AT) netvisao (DOT) pt> wrote