I need to rewrite a report in Oracle SQL that was originally created in Access. I am having trouble is structuring the report because there will be fields created from 4 formulas strung together. Each uses the results of the previous formula as an input. The formulas will be calculated using Case statements. I'm thinking of attempting this by utilizing sub queries because I cannot refer to an aliased case statement in another case statement in the same query. Does anyone have advise on the easiest way to do this?