Hello,
I have linked two tables - billed & paid. I am trying to create a report that will list all the billed customers and have a column that will show whether they are paid or not. I have linked the two tables by invoice #. Here are the main headers:
Invoice    Customer   Paid
The customer's name comes from the billed table and the paid field comes from the paid table. When I insert the {paid.paid} field into the report, it will only show the invoices that have been paid. I would like ALL the invoices to show in the report and the unpaid invoices to either show as blank in the Paid column or "N". I tried creating a formula field for the Paid column as follows:
if {billed.invoice} = {paid.invoice} then
formula = {paid.paid} else formula = " " end if
I sincerely appreciate any help, thanks.

Wow! I did not realize there were different link options. Thank you so much, I'm going to read up on the types of joins and their uses. I've had similar troubles in the past with other reports and I'm thinking this changing the joins may have fixed the problems. Thanks, DBlank

I see, that is good to know. I'll do some searching & studying. Thanks again