Just to be sure I've got this. The Tax ID is on the first line (of a two line record) for the last record related to each code?
In other words it would be a good and simple append but for the fact it is upsidedown for append purposes?
I have tried a quick experiment with a Cut and Paste version of your posted layout and seemed to get the result that you want but I assume there are other complications.
I used both lines for the detail trap, trapping on the decimal point of the value. Then both lines again for a footer trap trapping on the tax ID and making that a field as well.
Assuming that the suggestion above does not work for the full report, I'm wondering if one way might be to create each 2 line record as a single record, add the record number as a calculated field and then sort the resulting table on descending record number.
Export that inverted table to a new text file and you would should be in a position to grab the tax code as either an append or as a fill field.
Still, it would be nice to find a one pass solution so I will keep looking if my first suggestion is wide of the mark.
I hope this helps somehow.
(forgive the underscores, I couldn't figure out how to keep the spacing otherwise)
So what I have are two lines for each record, with multiple records for each tax ID but the tax ID shows up as the second to the last line for each grouping. Any thoughts? I used a two line trap to get the detail information of the amount and name, but I am having difficulty relating the tax ID to each of the detail lines. I am using version 6.01 Pro. I went through the training on version 7 and I thought there was something that addressed this but I am unable to recall what it was or if I could do it in version 6. Thanks in advance for the help. /b[/quote]
[size="1"][ November 24, 2003, 07:37 PM: Message edited by: Grant Perkins ][/size]