Split a row into two

Database
Enthusiast

Split a row into two

So currently I have code that gives an output of

FY08 1 N 99999999 07200880977 20060401 A 5066.00 16.66

Where the last two fields are periods of time in which payments were made. The first was a payment made from when the bill was sent out up to 30 days after, and the second is 31 days after the bill was sent out up to 60 days after. I need away to show both of these two payments on different lines with some sort of indication of what period the payments were made in. There are 13 different periods of time we are looking at.

Any and all suggestions will be very much appreciated.
2 REPLIES
Enthusiast

Re: Split a row into two

I suppose an example to go by would be helpful as well

FY08 1 N 99999999 07200880977 20060401 01 - 30 DAYS 5066.00

FY08 1 N 99999999 07200880977 20060401 31 - 60 DAYS 16.66

Enthusiast

Re: Split a row into two

Problem solved.... now how to delete topic...