I have a database that I need to extract records from based on matching values.

Job Task Status

House Framing Complete
House Siding Complete
House Painting Complete
Barn Framing Complete
Barn Siding Incomplete

The result I want from the data above would be to show the record "House" but not the record "Barn". If I could get the result to show only one instance of "House", that would be great, but if the result is that it shows the three records with "House", I'll use Excel to delete duplicates. My goal would be to count the number of unique records.

Thanks in advance.

Mike