Filtering and Grouping help

Post Author: helliott

CA Forum: General

I need to pull a list based on the following situation.

I need a list of custumers who have never buit a home at our community.

Database tracks this way.

Custumer Table - tracks customer specific information such as name, address etc....

Contract Table - tracks the properties associated with each customer and information specific to the contract details

I build a report that selects all customers with a contract to give a list of all owners. The Build field indicates if the custumer has built on the property with a under construction or a complete entry.

There are customers with more than one piece of property. I need the report to look at all the contracts for the customer and if any of them say under contract or complete then filter the customer off the list.