Hiya Steve:

>No problem. Let me try again. There is a certain record that is *not* showing up on the report, but you want it to, correct?
>
>I was asking you to show us the values for the above fields for that one particular record.

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.