If paid = "YES", your select won't select it...
>
>Now that was much more clear - thanks. Here is what you wanted.
>>
>For that record:
>>
>
paid = YES
>billed = YES
>closeclaim =
>claim_no = 0
>invoice_no = 1
>amt_paid = 330.00
>feesubmit = 24.00
>feesubmit1 = 22.00
>feesubmit2 = 37.50
>feesubmit3 = 248.00
>feesubmit4 = 0.00
>feesubmit5 = 0.00
>feesubmit6 = 0.00
>
>>
>>What if there ever needs to be an 8th fee? I see a normalization issue here...these fees should be split into multiple child records. But that is another topic for another time :)
>
>The paying agency wants a max of 6 sequences per claim, therefore the six services and feesubmits.
Steve Gibson