Method Community

Sorry Amanda, I completely missed this reply originally.  I am still havign an issue here and not wuite sure what you mean above.  Do I create a label and add this formula to the text property?  Or do I create a calculated field?  Either way, I can't get it to work.

I am trying to create a report that will list all the parts that belong to a customer, but it's only showing 1 item per customer.  Is there a way to specify the join type.  i would like to use a right outer join so it will show all the items by a customer.   My master table is "Customer" and my Detail table is ...

Thanks Amanda.  The use of sub reports would be a great tool to have in the future.  It could solve a lot of issues we are currently experiencing and would give more flexibility to reporting.

How exactly do you use the sub report tool in report designer?  I have tried to put them everywhere, but no reports are ever populated in the drop-down.   Is there any help files on these, because subreports are extremely useful