• futhre to my previous post.....care to fully explain what you mean by this:

    OUPUT:

    lngOrderID, lngBillingStepID, lngBillingStepID, lngSubBillingStepID =1, lngSubBillingStepID =2, lngSubBillingStepID=3

    I would like the lngSubBillingStepID to show their orginal value of 1,2,or 3. Not an aggregation.

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day