hi, everyone

i have a problem

table a

inv#    amount
1              1
2              3
3             3.1
4              2.1

table b (paid)

inv#    paidamount
2            1
4            2

i want to create a report which can list out the all invoice with paid
invoice number and paidamount

i tried to create a report but it just only list out the invoice, paid
invoice and paidamount (it was created to relationship between table a and
table b)

please help
thanks
jimmy